SQL Database Toolkit
Execute and manage SQL queries, inspect schemas, export data, create migrations, and backup databases for SQLite, PostgreSQL, MySQL, and SQLAlchemy-compatibl...
SQL Database Toolkit
Query, inspect, export, and manage databases via conversation. Supports SQLite (no setup) and PostgreSQL/MySQL (with connection string).
Quick Start
# 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
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
python3 skills/sql-db-toolkit/scripts/db_schema.py --db my.db
Export to CSV
python3 skills/sql-db-toolkit/scripts/db_export.py --db my.db --sql "SELECT * FROM orders" --output orders.csv
Backup Database
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
# 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
Related skills
- Downloads
- 925All time
- Security audit
- Review
- Last updated
- 6mo ago
- Current version
- v1.0.0
- License
- MIT-0
