database-integration

name	database-integration
description	Database integration - schema design, queries, migrations, optimization
sasmp_version	1.3.0
bonded_agent	04-database-design
bond_type	PRIMARY_BOND
atomic	true
single_responsibility	database_operations
parameters	{"type":"object","required":["action"],"properties":{"action":{"type":"string","enum":["design_schema","write_query","create_migration","optimize_performance"],"description":"The specific database action to perform"},"database_type":{"type":"string","enum":["postgresql","mysql","mongodb","redis","sqlite"],"default":"postgresql"},"orm":{"type":"string","enum":["prisma","drizzle","typeorm","sqlalchemy","mongoose"]},"query_type":{"type":"string","enum":["select","insert","update","delete","aggregate"]}}}
returns	{"type":"object","properties":{"success":{"type":"boolean"},"schema":{"type":"object"},"query":{"type":"string"},"migration":{"type":"string"},"performance_notes":{"type":"array","items":{"type":"string"}}}}
retry	{"max_attempts":3,"backoff":"exponential","initial_delay_ms":1000,"jitter":true}
logging	{"level":"INFO","events":["schema_designed","query_written","migration_created"],"metrics":["query_complexity","index_recommendations"]}

Database Integration Skill

Atomic skill for database operations including schema design, query writing, and performance optimization.

Responsibility

Single Purpose: Design and implement database schemas, queries, and migrations

Actions

design_schema

Design database schema with proper normalization and indexes.

// Input
{
  action: "design_schema",
  database_type: "postgresql",
  orm: "prisma"
}

// Output
{
  success: true,
  schema: {
    models: ["User", "Post", "Comment"],
    relationships: ["User hasMany Post", "Post hasMany Comment"],
    indexes: ["users_email_idx", "posts_author_idx"]
  },
  performance_notes: ["Composite index recommended for posts queries"]
}

write_query

Write optimized database queries.

create_migration

Create database migration scripts.

optimize_performance

Analyze and optimize query performance.

Validation Rules

function validateParams(params: SkillParams): ValidationResult {
  if (!params.action) {
    return { valid: false, error: "action is required" };
  }

   (params. ===  && !params.) {
     { : , :  };
  }

   { :  };
}