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.
npx claudepluginhub zate/cc-plugins --plugin devloopThis skill uses the workspace's default tool permissions.
Database design and optimization patterns.
Designs schemas, indexes, query optimizations, and migrations for SQL/NoSQL databases. For table design, N+1 fixes, normalization, ORMs, 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.
Share bugs, ideas, or general feedback.
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;