Databases

SQL, NoSQL, schema design, migrations, ORMs, and database operations

skills in category: 4,708
pages available: 197

Security grades appear on each card once the skill has been scanned. Newly imported skills may briefly show without a grade until the backfill job runs.

Open in full browser

Browse databases skills

Showing 1,369–1,392 of 4,708 skills

Schema Migration StrategyADesign database schema migration strategies. TRIGGERS - Use when user needs help with schema-migration-strategy related tasks.databasesgodatabaseVotes: 0GitHub stars: 26
Postgres PatternsAPostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.databasessqlgitVotes: 0GitHub stars: 2
Sql OptimizationAUniversal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.databasesgosqlVotes: 0GitHub stars: 2
Postgresql OptimizationAPostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem.databasesgosqlVotes: 0GitHub stars: 2
Postgresql Code ReviewAPostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).databasesgosqlVotes: 0GitHub stars: 2
Creating Oracle To Postgres Master Migration PlanADiscovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or assessing which .NET projects contain Oracle dependencies.databasessqltestingVotes: 0GitHub stars: 2
Scaffolding Oracle To Postgres Migration Test ProjectAScaffolds an xUnit integration test project for validating Oracle-to-PostgreSQL database migration behavior in .NET solutions. Creates the test project, transaction-rollback base class, and seed data manager. Use when setting up test infrastructure before writing migration integration tests, or when a test project is needed for Oracle-to-PostgreSQL validation.databasesgoc#Votes: 0GitHub stars: 2
Reviewing Oracle To Postgres MigrationAIdentifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting, timestamps, concurrent transactions, etc.). Use when planning a database migration, reviewing migration artifacts, or validating that integration tests cover Oracle/PostgreSQL differences.databasessqldatabaseVotes: 0GitHub stars: 2
Migrating Oracle To Postgres Stored ProceduresAMigrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.databasessqlgitVotes: 0GitHub stars: 2
Creating Oracle To Postgres Migration Bug ReportACreates structured bug reports for defects found during Oracle-to-PostgreSQL migration. Use when documenting behavioral differences between Oracle and PostgreSQL as actionable bug reports with severity, root cause, and remediation steps.databasessqldatabaseVotes: 0GitHub stars: 2
Create Spring Boot Kotlin ProjectACreate Spring Boot Kotlin Project SkeletondatabasesgojavaVotes: 0GitHub stars: 2
Create Spring Boot Java ProjectACreate Spring Boot Java Project SkeletondatabasesgojavaVotes: 0GitHub stars: 2
Ansible Role DesignBProduction-grade Ansible role structure patterns for directory layout, variable organization (defaults vs vars), handlers, and task organization, derived from analysis of 7 geerlingguy production roles.databasesgosqlVotes: 0GitHub stars: 2
Adr WritingAWrite Architectural Decision Records following MADR template. Applies Definition of Done criteria, marks gaps for later completion. Use when generating ADR documents from extracted decisions.databasespythongoVotes: 0GitHub stars: 3
DbADatabase workflow specialist. Generates migration files with rollback scripts, detects breaking schema changes, and validates query parameterization.databasestypescriptpythonVotes: 0GitHub stars: 86
Zero Downtime Database MigrationAUse when changing schema on a live production database without dropping traffic, doing expand/contract migrations, backfilling new columns on million-plus-row tables, dual-writing across schemas, renaming a hot column, splitting a table, or adding a foreign key to a big table. Triggers: ALTER TABLE locks the world, "must be removed in a separate deploy", expand-contract-cleanup phases, NOT NULL on populated column, foreign-key add on big table, dropping a column still read by old replicas, lo...databasesgorubyVotes: 0GitHub stars: 10
Supabase AdminASupabase administration, RLS policies, migrations, and schema design. Use for database architecture, Row Level Security, performance tuning, auth integration. Activate on "Supabase", "RLS", "migration", "policy", "schema", "auth.uid()". NOT for Supabase Auth UI configuration (use dashboard), edge functions (use cloudflare-worker-dev), or general SQL without Supabase context.databasesjavascriptgoVotes: 0GitHub stars: 10
Streaming Pipeline ArchitectAKafka Streams, Flink, Spark Streaming, and CDC for real-time data pipelines. Activate on: streaming, Kafka Streams, Flink, Spark Streaming, CDC, Debezium, real-time pipeline, event stream processing. NOT for: message broker setup (use event-driven-architecture-expert), batch processing (use batch-processing-optimizer).databasespythongoVotes: 0GitHub stars: 10
Postgresql OptimizationAExpert in PostgreSQL performance tuning, query optimization, and database administration. Specializes in EXPLAIN analysis, indexing strategies, connection pooling, partitioning, and production-grade PostgreSQL operations.databasesgosqlVotes: 0GitHub stars: 10
Postgres Explain AnalyzerAUse when a Postgres query is slow, p99 latency regressed after deploy, EXPLAIN ANALYZE output needs interpretation, the planner is choosing the wrong index, dead tuples are blowing up, autovacuum is falling behind, pg_stat_statements review is needed, or query plans regressed between releases. Triggers: "Seq Scan on big_table", "Rows Removed by Filter: 3M", "could not extend file", parameter-sniffing surprises, missing indexes, prepared-statement plan-cache regressions. NOT for schema design ...databasesgobashVotes: 0GitHub stars: 10
Postgres Connection PoolingAChoosing a Postgres connection pool mode that matches your workload — pgBouncer session/transaction/statement modes, the prepared-statement story (pgBouncer 1.21+), Supabase Supavisor's port-per-mode pattern (5432 vs 6543), AWS RDS Proxy pinning triggers, and `pg_stat_activity` diagnostics. Grounded in pgbouncer.org, supabase.com, AWS docs, and PostgreSQL docs.databasespythongoVotes: 0GitHub stars: 10
Outbox Pattern ImplementationAUse when you need to publish a message to Kafka / RabbitMQ / SNS atomically with a database commit, when fixing the dual-write hazard between DB and broker, deciding between polling-publisher and CDC (Debezium) relay, designing the outbox schema, handling at-least-once / idempotency on the consumer, or pruning a high-volume outbox table. Triggers: dual write, "we updated the DB but the event never published", outbox/inbox pattern, Debezium connector, EventRouter SMT, aggregate_type / aggregat...databasesrustgoVotes: 0GitHub stars: 10
Multi Tenant Architecture ExpertATenant isolation, row-level security, shared/siloed schema patterns for SaaS platforms. Activate on: multi-tenant, tenant isolation, RLS, shared database, SaaS architecture, tenant context, data isolation. NOT for: connection pooling (use database-connection-pool-manager), API gateway routing (use api-gateway-reverse-proxy-expert).databasestypescriptgoVotes: 0GitHub stars: 10
Kafka Consumer Group DesignADesign Kafka consumer groups that survive rebalances, hit the right delivery guarantee (at-most/at-least/exactly-once), and handle poison messages without stalling the topic. Use when picking a partition assignment strategy (Range vs Sticky vs Cooperative-Sticky vs the new KIP-848 protocol), tuning heartbeat / session / max.poll.interval timeouts, choosing manual vs auto offset commits, designing dead-letter or retry topics, or migrating from Classic to the next-gen Consumer protocol. NOT for...databasesgojavaVotes: 0GitHub stars: 10