Execute SQL queries against SQLite, PostgreSQL, and MySQL databases. Query, analyze, and manage data with natural language interface.
Execute SQL queries and database operations via natural language.
# SQLite
sql query "SELECT * FROM users LIMIT 5" --db path/to/db.sqlite
sql tables --db path/to/db.sqlite
sql schema users --db path/to/db.sqlite
# PostgreSQL
sql query "SELECT * FROM orders" --postgres "postgresql://user:pass@host/db"
# MySQL
sql query "SELECT * FROM products" --mysql "mysql://user:pass@host/db"
.sqlite, .db, .sqlite3)sql tables --db ~/.openclaw/memory/main.sqlite
sql schema telegram_messages --db ~/.openclaw/memory/main.sqlite
sql query "SELECT * FROM users WHERE created_at > date('now', '-7 days')" --db app.db --csv output.csv
sql analyze "orders" --group-by "status" --sum "amount" --db production.sqlite
| Task | Command |
|---|---|
| List tables | sql tables --db <file> |
| Describe table | sql schema <table> --db <file> |
| Sample data | sql sample <table> --limit 10 --db <file> |
| Export CSV | sql query "..." --csv out.csv --db <file> |
| Count rows | sql query "SELECT COUNT(*) FROM <table>" --db <file> |
| Find duplicates | sql duplicates <table> <column> --db <file> |
--read-onlyLIMIT 100sql indexes <table> --db <file>sql backup <db> --to backup.db--limit or stream output