From devloop
Provides patterns for database schema design, indexing, query optimization including N+1 fixes, migrations, relationships, and connection pooling using SQL in PostgreSQL and MySQL.
How this skill is triggered — by the user, by Claude, or both
Slash command
/devloop:database-patternsThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Database design and optimization patterns.
Database design and optimization patterns.
-- Single column
CREATE INDEX idx_users_email ON users(email);
-- Composite (order matters)
CREATE INDEX idx_orders_user_date ON orders(user_id, created_at);
-- Bad: N+1 queries
SELECT * FROM users;
SELECT * FROM orders WHERE user_id = 1;
SELECT * FROM orders WHERE user_id = 2;
...
-- Good: JOIN or eager load
SELECT u.*, o.* FROM users u
LEFT JOIN orders o ON o.user_id = u.id;
npx claudepluginhub zate/cc-plugins --plugin devloopDesigns database schemas, indexing strategies, query optimization, and migration patterns for SQL and NoSQL databases. Use for schema design, N+1 fixes, normalization, and performance tuning.
Provides best practices for database schema design, query optimization, migrations, indexing, N+1 avoidance, pagination, and transactions across PostgreSQL, MySQL, Oracle, SQLite. Use for schema design, queries, or migrations.
Guides database schema design, migrations, query optimization, indexes, transactions, and ORM patterns for SQLAlchemy or Django ORM.