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

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