Drizzle Db

• 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