Query and manage databases (SQLite, PostgreSQL, MySQL). Execute queries, explore schemas, and manage data.
Query and manage databases including SQLite, PostgreSQL, and MySQL. Execute queries, explore schemas, and manage data.
Database connection is configured via environment variables or command line options:
DATABASE_URL - Full connection stringDB_TYPE - sqlite, postgres, or mysql{baseDir}/db-tool.js --query "SELECT * FROM users LIMIT 10"
{baseDir}/db-tool.js --tables
{baseDir}/db-tool.js --describe "users"
{baseDir}/db-tool.js --execute "UPDATE users SET active = 1 WHERE id = 5"
| 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 |