database-query v1.0.0A

Immutable. This exact content is served forever at /api/v1/blob/258e1df4b07fa1c8.

---
name: database-query
display-name: Database Query Helper
description: Generate, optimize, and explain SQL queries - supports SQLite, PostgreSQL, MySQL with schema introspection, migration generation, and query performance analysis
version: 1.0.0
category: development
user-invocable: true
tags: [sql, database, query, optimization, migration, schema, postgresql, mysql, sqlite]
capabilities: [sql-generation, query-optimization, schema-introspection, migration-generation, explain-plan]
handler: ./handler.js
os: [win32, darwin, linux]
tools: [db-query, db-schema, db-optimize, db-migrate]
instructions: |
  Use this skill when the user needs help with SQL queries, database
  schema design, query optimization, or migration generation. Supports
  SQLite, PostgreSQL, and MySQL dialects. Can introspect the app's
  SQLite database for schema information.
examples:
  - input: "generate a query to find users who logged in this week"
    action: generate
  - input: "optimize SELECT * FROM orders WHERE status = 'pending'"
    action: optimize
  - input: "show schema for notes table"
    action: schema
  - input: "create migration to add email column to users"
    action: migrate
input-schema:
  type: string
  description: "Action (generate|optimize|schema|migrate|explain) followed by query or description"
output-schema:
  type: object
  properties:
    success: { type: boolean }
    action: { type: string }
    sql: { type: string }
    suggestions: { type: array }
    message: { type: string }
model-hints:
  context-window: small
  capability: text
cost: low
author: ChainlessChain
license: MIT
---

# Database Query Helper

Generate, optimize, and explain SQL queries.

## Usage

```
/database-query generate "<natural language description>"
/database-query optimize "<sql query>"
/database-query schema [table-name]
/database-query migrate "<description of change>"
/database-query explain "<sql query>"
```

## Supported Dialects

SQLite (default, app database), PostgreSQL, MySQL

## Features

- Natural language to SQL generation
- Query optimization suggestions (indexes, joins, subqueries)
- Schema introspection from app database
- Migration script generation (up/down)
- EXPLAIN plan analysis