Database Query

Generate, optimize, and explain SQL queries - supports SQLite, PostgreSQL, MySQL with schema introspection, migration generation, and query performance analysis

chainlesschain ce0e8d1 2 files · 12.2 KB Updated

File contents

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

chainlesschain/chainlesschain/tree/main/desktop-app-vue/src/main/ai-engine/cowork/skills/builtin/database-query commit ce0e8d189c

Frequently asked questions

npx skillmds@latest add chainlesschain/database-query