Browse reusable instructions for your AI tools. Copy and customize a prompt, or download a skill for a supported agent.
This skill should be used when the user asks to optimize slow T-SQL queries, fix SQL Server performance regressions, improve SARGability, rewrite joins, prove whether joins can be removed, compare temp-table data types, select rewrite templates, diagnose parameter sniffing, evaluate query hints, ...
Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations...
SQL Optimization Patterns workflow skill. Use this skill when the user needs Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis and the operator should preserve the upstream workflow, copied support files, and p...
Review and tune SQLite schemas, queries, indexes, and pragmas. Connects to the actual database to gather concrete evidence (EXPLAIN QUERY PLAN, page counts, table stats) before recommending changes.
PostgreSQL development best practices for schema design, query optimization, and database administration
SQL development best practices for writing efficient, secure, and maintainable database queries
Advises on database selection, schema design, indexing, query optimization, and migration. Covers SQL, NoSQL, Graph, Columnar, Key-Value, Time Series, NewSQL, Vector, Serverless, Data Warehouse, Embedded, Multi-Model, Streaming, and Decentralized databases. 100+ database technologies including Po...
Deep operational guide for 20 relational/SQL databases. PostgreSQL tuning (VACUUM, WAL, partitioning, extensions, PgBouncer), MySQL/MariaDB (InnoDB, Vitess, Galera, ProxySQL), Oracle (RAC, Data Guard), MS SQL Server (AlwaysOn AG, columnstore), SQLite, Db2, HANA, and managed cloud options (Aurora,...
Database expert for query optimization, indexing, schema design, and performance tuning
VaultCPA database schema reference with 50+ Prisma models, relationships, and query patterns. Use when working with database models, designing features, or understanding data structure.
LibreOffice Base workflow skill. Use this skill when the user needs Database management, forms, reports, and data operations with LibreOffice Base and the operator should preserve the upstream workflow, copied support files, and provenance before merging or handing off.
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...
Supabase Postgres Best Practices workflow skill. Use this skill when the user needs Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations and the operator should preser...
\"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...
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.
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.
CockroachDB distributed SQL database. Use for geo-distributed data.
IBM Db2 enterprise database. Use for IBM mainframe systems.
Analyze an existing PostgreSQL database to identify tables that would benefit from conversion to TimescaleDB hypertables
Database performance troubleshooting across all engines. PostgreSQL (pg_stat_statements, auto_explain, pg_locks, EXPLAIN ANALYZE BUFFERS), MySQL (EXPLAIN FORMAT=TREE, Performance Schema, InnoDB status, optimizer trace), MongoDB (explain executionStats, currentOp, profiler), Redis (SLOWLOG, LATENC...
ClickHouse is a column-oriented database management system designed for online analytical processing. Where traditional row-based databases excel at transactional workloads, ClickHouse shines when you need to scan and aggregate billions of rows in seconds. It achieves this through columnar storag...
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.