SQL Database Toolkit

Execute and manage SQL queries, inspect schemas, export data, create migrations, and backup databases for SQLite, PostgreSQL, MySQL, and SQLAlchemy-compatibl...

Query, inspect, export, and manage databases via conversation. Supports SQLite (no setup) and PostgreSQL/MySQL (with connection string).

Quick Start

bash

# SQLite - no setup needed
python3 skills/sql-db-toolkit/scripts/db_query.py --db my.db --sql "SELECT * FROM users LIMIT 5"

# PostgreSQL
python3 skills/sql-db-toolkit/scripts/db_query.py --conn "postgresql://user:pass@host:5432/db" --sql "SELECT table_name FROM information_schema.tables"

Common Commands

Query Database

bash

python3 skills/sql-db-toolkit/scripts/db_query.py --db my.db --sql "SELECT id, name, email FROM users WHERE active = 1" --format table

Inspect Schema

bash

python3 skills/sql-db-toolkit/scripts/db_schema.py --db my.db

Export to CSV

bash

python3 skills/sql-db-toolkit/scripts/db_export.py --db my.db --sql "SELECT * FROM orders" --output orders.csv

Backup Database

bash

python3 skills/sql-db-toolkit/scripts/db_backup.py --db my.db --output backup/

Scripts

Script	Purpose
db_query.py	Execute SQL queries with formatted output (table/JSON/CSV)
db_schema.py	Inspect tables, columns, indexes, FKs, triggers
db_export.py	Export query results to CSV, JSON, or SQL dump
db_backup.py	Backup SQLite DB or dump PostgreSQL/MySQL
db_migrate.py	Compare schemas, generate migration SQL

Connection Strings

python

# SQLite
sqlite:///path/to/db.sqlite

# PostgreSQL
postgresql://user:password@host:5432/database

# MySQL
mysql+pymysql://user:password@host:3306/database

Options

All scripts support --help for full argument reference. Key shared options:

• --db <path> — SQLite database file path
• --conn <url> — SQLAlchemy connection string
• --sql <query> — SQL query to execute
• --format table|json|csv — Output format
• --verbose — Show execution time and row counts