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