Query and manage databases including SQLite, PostgreSQL, and MySQL. Execute queries, explore schemas, and manage data.
Setup
Database connection is configured via environment variables or command line options:
DATABASE_URL- Full connection stringDB_TYPE- sqlite, postgres, or mysql
Usage
Query SQLite
{baseDir}/db-tool.js --query "SELECT * FROM users LIMIT 10"
List Tables
{baseDir}/db-tool.js --tables
Describe Table
{baseDir}/db-tool.js --describe "users"
Execute SQL
{baseDir}/db-tool.js --execute "UPDATE users SET active = 1 WHERE id = 5"
Options
| Option | Description | Required |
|---|---|---|
--query |
Execute SELECT query | No |
--execute |
Execute INSERT/UPDATE/DELETE | No |
--tables |
List all tables | No |
--describe |
Show table schema | No |
--database |
Database file or connection string | No |
--type |
Database type: sqlite, postgres, mysql | No |
When to Use
- Querying databases for debugging
- Data exploration and analysis
- Running migrations
- Database administration tasks