---

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

Skill Configuration

atomic: true single_responsibility: database_operations

Parameter Schema

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]

Return Schema

returns: type: object properties: success: { type: boolean } schema: { type: object } query: { type: string } migration: { type: string } performance_notes: { type: array, items: { type: string } }

Retry Configuration

retry: max_attempts: 3 backoff: exponential initial_delay_ms: 1000 jitter: true

Observability

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.

Copy// 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

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

  if (params.action === 'write_query' && !params.query_type) {
    return { valid: false, error: "query_type required for write_query" };
  }

  return { valid: true };
}

Error Handling

Logging Hooks

Copy{
  "on_invoke": "log.info('database-integration invoked', { action, database_type })",
  "on_success": "log.info('Database operation completed', { schema, performance_notes })",
  "on_error": "log.error('Database skill failed', { error })"
}

Unit Test Template

Copyimport { describe, it, expect } from 'vitest';
import { databaseIntegration } from './database-integration';

describe('database-integration skill', () => {
  describe('design_schema', () => {
    it('should create normalized schema', async () => {
      const result = await databaseIntegration({
        action: 'design_schema',
        database_type: 'postgresql',
        orm: 'prisma'
      });

      expect(result.success).toBe(true);
      expect(result.schema.indexes.length).toBeGreaterThan(0);
    });

    it('should recommend indexes for foreign keys', async () => {
      const result = await databaseIntegration({
        action: 'design_schema',
        database_type: 'postgresql'
      });

      expect(result.schema.indexes).toContain(expect.stringMatching(/_idx$/));
    });
  });

  describe('optimize_performance', () => {
    it('should detect N+1 queries', async () => {
      const result = await databaseIntegration({
        action: 'optimize_performance',
        database_type: 'postgresql'
      });

      expect(result.success).toBe(true);
      expect(result.performance_notes).toBeDefined();
    });
  });
});

Integration

• Bonded Agent: 04-database-design
• Upstream Skills: backend-development
• Downstream Skills: fullstack-testing

Version History