Drizzle DB Connector

Drizzle DB Connector

Execute SQL queries against the project's database through Drizzle ORM.

When to use

• User asks about database contents or data
• Need to inspect database schema or tables
• Querying data for analysis or debugging
• Checking database state

How to use

Run queries using the query script located in this skill's directory:

node .claude/​skills/​drizzle-db/​scripts/​query.js "SELECT * FROM users LIMIT 10"

The script:

• Connects to the database using the project's Drizzle configuration
• Executes the SQL query
• Returns results as JSON

Configuration

This skill is configured during installation:

• dialect: Database type (sqlite/​postgres/​mysql)
• databasePath: For SQLite - direct path to .db file (e.g., ./​apps/​web/​data/​app.db)
• drizzleConfigPath: For Postgres/​MySQL - path to drizzle.config.ts
• readOnly: Whether to enforce read-only queries (default: true)

Configuration is stored in .claude/​skills/​drizzle-db/​.config.json

Example config for SQLite:

{
  "dialect": "sqlite",
  "databasePath": "./​apps/​web/​data/​app.db",
  "readOnly": true
}

Read-only mode

When readOnly is true (default), the following operations are blocked:

• INSERT
• UPDATE
• DELETE
• DROP
• ALTER
• TRUNCATE
• CREATE

Only SELECT queries are allowed for safety.

Examples

# Get all users
node .claude/​skills/​drizzle-db/​scripts/​query.js "SELECT * FROM users"

# Count records
node .claude/​skills/​drizzle-db/​scripts/​query.js "SELECT COUNT(*) FROM posts"

# Join tables
node .claude/​skills/​drizzle-db/​scripts/​query.js "SELECT u.name, p.title FROM users u JOIN posts p ON u.id = p.user_id"

# Get schema information
node .claude/​skills/​drizzle-db/​scripts/​query.js "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'"

Limitations

• Requires Node.js and the project's Drizzle setup
• Read-only mode prevents data modifications by default
• Queries timeout after 30 seconds
• Results are limited to 1000 rows by default

Troubleshooting

If queries fail:

1. Verify drizzle.config.ts path is correct in .config.json
2. Ensure database connection credentials are set
3. Check that Drizzle dependencies are installed: npm install drizzle-orm
4. Verify database is accessible from current environment