SQL Database Toolkit — SQL 数据库工具包

SQL Database 工具kit

查询, inspect, 导出, and manage databases via conversation. Supports SQLite (no 设置up) and PostgreSQL/MySQL (with connection string).

Quick 启动 # SQLite - no 设置up needed python3 技能s/sql-db-工具kit/scripts/db_查询.py --db my.db --sql "SELECT FROM users LIMIT 5"

# PostgreSQL python3 技能s/sql-db-工具kit/scripts/db_查询.py --conn "postgresql://user:pass@host:5432/db" --sql "SELECT table_name FROM in格式化ion_模式.tables"

Common Commands 查询 Database python3 技能s/sql-db-工具kit/scripts/db_查询.py --db my.db --sql "SELECT id, name, emAIl FROM users WHERE active = 1" --格式化 table

Inspect 模式 python3 技能s/sql-db-工具kit/scripts/db_模式.py --db my.db

导出 to CSV python3 技能s/sql-db-工具kit/scripts/db_导出.py --db my.db --sql "SELECT FROM orders" --输出 orders.csv

备份 Database python3 技能s/sql-db-工具kit/scripts/db_备份.py --db my.db --输出 备份/

Scripts Script Purpose db_查询.py 执行 SQL queries with 格式化ted 输出 (table/JSON/CSV) db_模式.py Inspect tables, columns, 索引es, FKs, triggers db_导出.py 导出 查询 结果s to CSV, JSON, or SQL dump db_备份.py 备份 SQLite DB or dump PostgreSQL/MySQL db_迁移.py Compare 模式s, 生成 迁移 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 分享d options:

--db — SQLite database file path --conn — SQLAlchemy connection string --sql <查询> — SQL 查询 to 执行 --格式化 table|json|csv — 输出 格式化 --verbose — Show execution time and row counts