DB Tool

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 string
• DB_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