indexes
Analyze database queries and recommend missing indexes with performance impact analysis
Browse reusable instructions for your AI tools. Copy and customize a prompt, or download a skill for a supported agent.

Analyze database queries and recommend missing indexes with performance impact analysis
PostgreSQL Optimization Workflow workflow skill. Use this skill when the user needs PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management and the operator should preserve the upstream workflow, copied support file...
Database Design workflow skill. Use this skill when the user needs Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases and the operator should preserve the upstream workflow, copied support files, and provenance before merging or h...
Create a new database migration with timestamp-based naming. Use when adding schema changes.
\"Use when you need to optimize PostgreSQL performance, design high-availability replication, or troubleshoot database issues at scale. Invoke this agent for query optimization, configuration tuning, replication setup, backup strategies, and mastering advanced PostgreSQL features for enterprise d...
Automatically manages PostgreSQL backups with pgBackRest and Wasabi S3 storage when working with FairDB databases
Apache Cassandra is a distributed NoSQL database designed for high availability and linear scalability. Learn CQL (Cassandra Query Language), data modeling with partition keys, replication strategies, and integration with Node.js using the DataStax driver.
Deep operational guide for 12 document databases. MongoDB (aggregation pipeline, sharding, Atlas, CSFLE, Vector Search), Elasticsearch/OpenSearch (ILM, mapping, query DSL, tiering), CouchDB (multi-master, PouchDB), Couchbase (N1QL, XDCR, Capella), RavenDB, DocumentDB, Cosmos DB, Firestore, Ferret...
Database selection: PostgreSQL as default, Redis for ephemeral, NoSQL comparison, specialized databases, polyglot persistence. Use when choosing databases.
Database schema design principles and patterns. Normalization (1NF through 5NF/BCNF), strategic denormalization for read performance, multi-tenancy schema patterns (shared schema, schema-per-tenant, database-per-tenant), primary key strategies (UUID v7, ULID, KSUID, Snowflake ID, BIGSERIAL, CUID2...
Design and operate databases avoiding common scaling, reliability, and data integrity traps.
Build type-safe database queries with Drizzle ORM patterns.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Validate pending migrations for foreign key consistency, rollback safety, and best practices
Use Performance Studio when an MCP-compatible agent needs to parse SQL Server .sqlplan files, surface performance warnings, inspect missing-index suggestions, and turn execution-plan evidence into a reviewable tuning workflow.
ArangoDB multi-model database with graphs. Use for multi-model workloads.
Async Rust SQL toolkit with compile-time checked queries.
Verifies database migrations are safe, reversible, don't lose data, include proper indexes, and follow multi-tenancy patterns
Pull live MySQL schema into files, inspect diffs, and push reviewed changes back with a repeatable workflow.
Compare checked-in SQL against live MySQL, PostgreSQL, SQLite, or SQL Server schemas and generate a reviewable apply plan before agents touch production databases.
Run scheduled backups with retention rules and storage targets across PostgreSQL, MySQL, MariaDB, and MongoDB from one place.
Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables
Try another platform, a broader search, or fewer filters.
Explore all resourcesResource formats: Prompts are ready to copy into a conversation. Skills install into the compatible agent shown on their page.
How it worksInclude the instructions, intended platforms, author, and license. Submissions are reviewed before publication.