About

Imported from borghei/claude-skills (engineering/sql-database-assistant/SKILL.md). Install upstream with npx skills add borghei/claude-skills --skill sql-database-assistant. Copyright stays with the author (MIT + Commons Clause).

SQL Database Assistant

Name: sql-database-assistant
Author: borghei

Category: Engineering Domain: Database Development & Optimization

Overview

The SQL Database Assistant skill provides tools for analyzing SQL query performance, exploring database schemas from DDL files, and generating migration SQL from schema differences. It helps teams write efficient queries, maintain clean schemas, and manage database evolution safely.

Clarify First

Before analyzing or generating, confirm these inputs. If any is unknown or vague, ASK — do not assume:

Task — query optimization / schema documentation / migration generation (selects the script)
SQL input — the query, the DDL file, or the from/to schema pair to operate on (the script's actual input)
Target database / dialect — Postgres / MySQL / etc. (changes index recommendations and migration SQL syntax)

Stop rule: ask only the 2-3 that most change the output. If the user says "just draft it," proceed and list your assumptions at the top of the artifact.

Quick Start

# Analyze a SQL query for performance issues
python scripts/query_optimizer.py --file slow_query.sql

# Analyze inline SQL
python scripts/query_optimizer.py --query "SELECT * FROM users WHERE name LIKE '%john%'"

# Explore schema from DDL file
python scripts/schema_explorer.py --file schema.sql

# Generate migration from schema diff
python scripts/migration_generator.py --from old_schema.sql --to new_schema.sql

# JSON output
python scripts/query_optimizer.py --file query.sql --format json

Tools Overview

query_optimizer.py

Analyzes SQL queries for performance issues and optimization opportunities.

Feature	Description
SELECT * detection	Flags queries selecting all columns
Missing index hints	Identifies WHERE/JOIN columns likely needing indexes
N+1 detection	Flags correlated subquery patterns
Full table scan	Detects queries without WHERE clauses on large tables
JOIN analysis	Checks join conditions and types
LIKE optimization	Flags leading wildcard LIKE patterns

schema_explorer.py

Generates documentation from SQL DDL (CREATE TABLE) files.

Feature	Description
Table catalog	Lists all tables with column counts
Column details	Documents types, nullability, defaults
Index listing	Catalogs indexes and their columns
Relationship mapping	Identifies foreign key relationships
Markdown output	Generates schema documentation

migration_generator.py

Generates migration SQL by comparing two schema DDL files.

Feature	Description
Column additions	ALTER TABLE ADD COLUMN for new columns
Column removals	ALTER TABLE DROP COLUMN for removed columns
Type changes	ALTER TABLE ALTER COLUMN for type modifications
New tables	CREATE TABLE for entirely new tables
Dropped tables	DROP TABLE for removed tables
Index changes	CREATE/DROP INDEX for index differences

Workflows

Query Optimization Workflow

Identify slow queries - Collect queries from slow query log
Analyze - Run query_optimizer.py on each query
Review findings - Prioritize by estimated impact
Optimize - Apply suggested improvements
Verify - Re-analyze to confirm optimization

Schema Documentation Workflow

Export DDL - Dump schema from database
Explore - Run schema_explorer.py to generate docs
Review - Check relationships and data types
Publish - Include in project documentation

Migration Workflow

Capture current - Export current schema DDL
Define target - Write desired schema DDL
Generate migration - Run migration_generator.py
Review SQL - Check generated migration for safety
Test - Apply to staging database first
Deploy - Apply to production with rollback plan

CI Integration

# Lint SQL queries
python scripts/query_optimizer.py --file queries/ --format json --strict

# Generate schema docs
python scripts/schema_explorer.py --file schema.sql --format markdown > SCHEMA.md

Reference Documentation

SQL Optimization - Index strategies, query patterns, anti-patterns

Common Patterns Quick Reference

Query Anti-Patterns

Pattern	Issue	Fix
`SELECT *`	Fetches unnecessary data	List specific columns
`LIKE '%term%'`	Cannot use index	Use full-text search
Correlated subquery	N+1 query pattern	Rewrite as JOIN
No WHERE clause	Full table scan	Add filtering conditions
`OR` in WHERE	Poor index usage	Use UNION or IN
Functions on indexed columns	Prevents index use	Apply to value side

Index Guidelines

Query Pattern	Index Type
`WHERE col = value`	B-tree on col
`WHERE col1 = v AND col2 = v`	Composite (col1, col2)
`ORDER BY col`	B-tree on col
`WHERE col LIKE 'prefix%'`	B-tree on col
`WHERE col IN (...)`	B-tree on col
Full-text search	Full-text index

Migration Safety

Always generate rollback SQL alongside forward migration
Test migrations against a copy of production data
Add columns as nullable first, then backfill, then add constraints
Never rename columns directly; add new, migrate data, drop old

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml

targets:
  - https://api.opensmartroute.ai/api/v1/registry/borghei-claude-skills-sql-database-assistant/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

borghei-claude-skills-sql-database-assistant.ocm.jsonjson

{
  "ocm": "1",
  "id": "borghei-claude-skills-sql-database-assistant",
  "kind": "skill",
  "name": "sql-database-assistant",
  "description": "This skill should be used when the user asks to \"optimize SQL queries\", \"explore database schemas\", \"generate migration SQL\", \"analyze query performance\", or \"document database structure\".",
  "publisher": "borghei",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "data_analysis",
      "coding"
    ],
    "tags": [
      "skill-md",
      "sql",
      "database",
      "optimization",
      "migration",
      "schema",
      "skills-sh"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "This skill should be used when the user asks to \"optimize SQL queries\", \"explore database schemas\", \"generate migration SQL\", \"analyze query performance\", or \"document database structure\"."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "skills.sh",
      "repository": "https://github.com/borghei/claude-skills",
      "path": "engineering/sql-database-assistant/SKILL.md",
      "ref": "HEAD",
      "url": "https://github.com/borghei/claude-skills/blob/HEAD/engineering/sql-database-assistant/SKILL.md",
      "key": "borghei/claude-skills/engineering/sql-database-assistant/SKILL.md"
    },
    "license": "MIT + Commons Clause"
  },
  "instructions": "# SQL Database Assistant\n\n> **Category:** Engineering\n> **Domain:** Database Development & Optimization\n\n## Overview\n\nThe **SQL Database Assistant** skill provides tools for analyzing SQL query performance, exploring database schemas from DDL files, and generating migration SQL from schema differences. It helps teams write efficient queries, maintain clean schemas, and manage database evolution safely.\n\n## Clarify First\n\nBefore analyzing or generating, confirm these inputs. If any is unknown or vague, ASK — do not assume:\n\n- [ ] **Task** — query optimization / schema documentation / migration ",
  "cost": {
    "context_tokens": 1350
  }
}

Fetch it by URL: GET /api/v1/registry/borghei-claude-skills-sql-database-assistant/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.