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