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 |
Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。