sdd-database

Plugin sdd-database from marketplace eli-marketplace in bingeli1379/eli-marketplace. Commands read from the repo's manifest — 6 days ago.

Skills (8)

• database-schema-design

  Database schema design for PostgreSQL/MySQL with normalization, relationships, constraints. Use for new databases, schema reviews, migrations, or encountering missing PKs/FKs, wrong data types, premature denormalization, EAV anti-pattern.

• mongodb-query-optimizer

  Use when optimizing MongoDB queries and aggregation pipelines — index selection, explain-plan analysis, and read/write performance. Load when a repo uses MongoDB and a query, pipeline, or index needs tuning.

• mongodb-schema-design

  Use when designing or reviewing MongoDB document schemas — embedding vs referencing, indexing strategy, schema validation, and modeling for the application's query patterns. Load when a repo uses MongoDB and you are shaping collections or documents.

• postgres-pro

  Use when a task hits PostgreSQL-specific capabilities rather than portable SQL tuning — JSONB columns and GIN indexing, streaming or logical replication and its lag, VACUUM / autovacuum / table bloat, PostgreSQL extensions (PostGIS, pgvector, pg_trgm), and the pg_stat_* views. For portable PG/MySQL

• sql-expert

  Use when writing or debugging SQL queries — complex joins, subqueries, CTEs, window functions — or translating queries across PostgreSQL, MySQL, SQLite, and SQL Server dialects. For performance tuning use sql-query-optimization (PostgreSQL/MySQL) or sql-optimization (SQL Server/Oracle); for schema/n

• sql-optimization

  Use when tuning SQL performance on SQL Server / T-SQL / Oracle — stored-procedure performance, execution-plan analysis, index strategy, SARGable predicates, pagination (OFFSET FETCH / keyset), large result sets, or "will this query scale" capacity questions. For PostgreSQL/MySQL query tuning use sql

• sql-query-optimization

  Use when tuning PostgreSQL/MySQL query performance — EXPLAIN ANALYZE, N+1 problems, missing/covering indexes, sequential scans, OFFSET pagination, temp-table spills, inefficient JOINs. For SQL Server / T-SQL / Oracle / stored-procedure tuning use sql-optimization; for authoring or debugging queries

• sqlserver-diagnostics

  Use when a SQL Server instance itself is the suspect — timeouts, blocking, unexplained slowness, "which query is eating the server", or you need wait statistics, currently-running requests, or plan-cache totals. Start here before touching an index or a plan. For tuning a known query or stored proced

Subagents (1)

• database-engineer

  Database specialist. Handles schema design, migration strategy, query optimization, indexing, data integrity, and performance tuning across SQL Server, PostgreSQL, MongoDB, and analytics stores. - agent-guidelines - engineering-checklist

Similar plugins