mcpbeat

Databases Skills

1 633 database skills from 232 authors. They work on schemas, queries and moving data between them. Half of them fit into 2 236 tokens or less — that is what one costs your context window when the agent loads it. 285 ship runnable scripts rather than instructions alone. 7 of them cannot work without an MCP server, most often rube. We also found 383 copies of these same skills sitting in other people's repositories — counted once here, not 383 times.

1 633 unique 232 authors 712 updated this month 156 from vendors

2 236
tokens, median
what a typical one costs in context
285
ship scripts
code that runs, not instructions alone
7
need a server
most often rube
383
copies elsewhere
counted once here, not once per repository

1 441–1 488 of 1 633

page 31 of 35
Managing Database Sharding
ComeOnOliver

| This skill assists with managing database sharding strategies. It is activated when the user needs to implement horizontal database sharding to scale beyond single-server limitations. The skill supports designing sharding strategies, distributing data across multiple database instances, and implementing consistent hashing, automatic rebalancing, and cross-shard query coordination. Use this skill when the user mentions "database sharding", "sharding implementation", "scale database", or "horizontal partitioning". The plugin helps design and implement sharding for high-scale applications.

804 tokens
Database Test Helper
ComeOnOliver

| Database Test Helper - Auto-activating skill for Test Automation. Part of the Test Automation skill category.

314 tokens
Managing Database Testing
ComeOnOliver

| This skill manages database testing by generating test data, wrapping tests in transactions, and validating database schemas. It is used to create robust and reliable database interactions. Claude uses this skill when the user requests database testing utilities, including test data generation, transaction management, schema validation, or migration testing. Trigger this skill by mentioning "database testing," "test data factories," "transaction rollback," "schema validation," or using the `/db-test` or `/dbt` commands.

770 tokens
Monitoring Database Transactions
ComeOnOliver

| This skill enables Claude to monitor database transactions for performance and lock issues using the database-transaction-monitor plugin. It is triggered when the user requests transaction monitoring, lock detection, or rollback rate analysis for databases. Use this skill when the user mentions "monitor database transactions," "detect long-running transactions," "identify lock contention," "track rollback rates," or asks about "transaction anomalies." The skill leverages the `/txn-monitor` command to provide real-time alerts and insights into database health.

696 tokens
Designing Database Schemas
ComeOnOliver

| Process use when you need to work with database schema design. This skill provides schema design and migrations with comprehensive guidance and automation. Trigger with phrases like "design schema", "create migration", or "model database".

2k tokens
Detecting Database Deadlocks
ComeOnOliver

| Process use when you need to work with deadlock detection. This skill provides deadlock detection and resolution with comprehensive guidance and automation. Trigger with phrases like "detect deadlocks", "resolve deadlocks", or "prevent deadlocks".

2k tokens
Detecting Performance Bottlenecks
ComeOnOliver

| Execute this skill enables AI assistant to detect and resolve performance bottlenecks in applications. it analyzes cpu, memory, i/o, and database performance to identify areas of concern. use this skill when you need to diagnose slow application performance, op... Use when optimizing performance. Trigger with phrases like 'optimize', 'performance', or 'speed up'.

890 tokens
Filtering Query Builder
ComeOnOliver

| Filtering Query Builder - Auto-activating skill for API Development. Part of the API Development skill category.

322 tokens
Firestore Operations Manager
ComeOnOliver

| Manages Firebase/Firestore operations including CRUD, queries, batch processing, A2A agent communication, MCP server integration, and Cloud Run service coordination. Activates when you request "firestore operations", "create firestore document", "query firestore", "A2A agent communication", "MCP server setup", "agent-to-agent messaging", or "Cloud Run firestore integration". Handles both basic database operations for regular users and advanced A2A framework patterns for AI agents.

4k tokens
Generating Database Seed Data
ComeOnOliver

| Process this skill enables AI assistant to generate realistic test data and database seed scripts for development and testing environments. it uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. u... Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.

2k tokens
Generating Orm Code
ComeOnOliver

| Execute use when you need to work with ORM code generation. This skill provides ORM model and code generation with comprehensive guidance and automation. Trigger with phrases like "generate ORM models", "create entity classes", or "scaffold database models".

2k tokens
Generating REST Apis
ComeOnOliver

| Generate complete REST API implementations from OpenAPI specifications or database schemas. Use when generating RESTful API implementations. Trigger with phrases like "generate REST API", "create RESTful API", or "build REST endpoints".

1k tokens
Generating Stored Procedures
ComeOnOliver

| Use when you need to generate, validate, or deploy stored procedures for PostgreSQL, MySQL, or SQL Server. Creates database functions, triggers, and procedures with proper error handling and transaction management. Trigger with phrases like "generate stored procedure", "create database function", "write SQL procedure", "add trigger to table", or "create CRUD procedures".

2k tokens
Implementing Database Audit Logging
ComeOnOliver

| Process use when you need to track database changes for compliance and security monitoring. This skill implements audit logging using triggers, application-level logging, CDC, or native logs. Trigger with phrases like "implement database audit logging", "add audit trails", "track database changes", or "monitor database activity for compliance".

2k tokens
Implementing Database Caching
ComeOnOliver

| Process use when you need to implement multi-tier caching to improve database performance. This skill sets up Redis, in-memory caching, and CDN layers to reduce database load. Trigger with phrases like "implement database caching", "add Redis cache layer", "improve query performance with caching", or "reduce database load".

2k tokens
Managing API Cache
ComeOnOliver

| Implement intelligent API response caching with Redis, Memcached, and CDN integration. Use when optimizing API performance with caching. Trigger with phrases like "add caching", "optimize API performance", or "implement cache layer".

1k tokens
Managing Database Migrations
ComeOnOliver

| Process use when you need to work with database migrations. This skill provides schema migration management with comprehensive guidance and automation. Trigger with phrases like "create migration", "run migrations", or "manage schema versions".

2k tokens
Managing Database Partitions
ComeOnOliver

| Process use when you need to work with database partitioning. This skill provides table partitioning strategies with comprehensive guidance and automation. Trigger with phrases like "partition tables", "implement partitioning", or "optimize large tables".

2k tokens
Managing Database Recovery
ComeOnOliver

| Process use when you need to work with database operations. This skill provides database management and optimization with comprehensive guidance and automation. Trigger with phrases like "manage database", "optimize database", or "configure database".

2k tokens
Managing Database Replication
ComeOnOliver

| Process use when you need to work with database scalability. This skill provides replication and sharding with comprehensive guidance and automation. Trigger with phrases like "set up replication", "implement sharding", or "scale database".

2k tokens
Managing Database Sharding
ComeOnOliver

| Process use when you need to work with database sharding. This skill provides horizontal sharding strategies with comprehensive guidance and automation. Trigger with phrases like "implement sharding", "shard database", or "distribute data".

2k tokens
Modeling Nosql Data
ComeOnOliver

| Build use when you need to work with NoSQL data modeling. This skill provides NoSQL database design with comprehensive guidance and automation. Trigger with phrases like "model NoSQL data", "design document structure", or "optimize NoSQL schema".

2k tokens
Monitoring Error Rates
ComeOnOliver

Monitor and analyze application error rates to improve reliability. Use when tracking errors in applications including HTTP errors, exceptions, and database issues. Trigger with phrases like "monitor error rates", "track application errors", or "analyze error patterns".

1k tokens
Modeling Nosql Data
ComeOnOliver

| This skill enables Claude to design NoSQL data models. It activates when the user requests assistance with NoSQL database design, including schema creation, data modeling for MongoDB or DynamoDB, or defining document structures. Use this skill when the user mentions "NoSQL data model", "design MongoDB schema", "create DynamoDB table", or similar phrases related to NoSQL database architecture. It assists in understanding NoSQL modeling principles like embedding vs. referencing, access pattern optimization, and sharding key selection.

774 tokens
Optimizing Database Connection Pooling
ComeOnOliver

| Process use when you need to work with connection management. This skill provides connection pooling and management with comprehensive guidance and automation. Trigger with phrases like "manage connections", "configure pooling", or "optimize connection usage".

2k tokens
Generating Orm Code
ComeOnOliver

| This skill enables Claude to generate ORM models and database schemas. It is triggered when the user requests the creation of ORM models, database schemas, or wishes to generate code for interacting with databases. The skill supports various ORMs including TypeORM, Prisma, Sequelize, SQLAlchemy, Django ORM, Entity Framework, and Hibernate. Use this skill when the user mentions terms like "ORM model", "database schema", "generate entities", "create migrations", or specifies a particular ORM framework like "TypeORM entities" or "SQLAlchemy models". It facilitates both database-to-code and code-to-database schema generation.

800 tokens
Analyzing Query Performance
ComeOnOliver

| This skill enables Claude to analyze and optimize database query performance. It activates when the user discusses query performance issues, provides an EXPLAIN plan, or asks for optimization recommendations. The skill leverages the query-performance-analyzer plugin to interpret EXPLAIN plans, identify performance bottlenecks (e.g., slow queries, missing indexes), and suggest specific optimization strategies. It is useful for improving database query execution speed and resource utilization.

790 tokens
Redis Cache Manager
ComeOnOliver

| Redis Cache Manager - Auto-activating skill for Backend Development. Part of the Backend Development skill category.

318 tokens
Tracking Resource Usage
ComeOnOliver

| This skill enables Claude to track and optimize resource usage across an application stack. It is activated when the user requests insights into resource consumption, performance bottlenecks, or cost optimization opportunities. The skill uses the resource-usage-tracker plugin to monitor CPU, memory, disk I/O, network I/O, file descriptors, database connections, and thread/process counts. Use this skill when the user mentions "resource usage", "performance optimization", "cost optimization", "track resources", or "right-sizing".

850 tokens
Tracking Application Response Times
ComeOnOliver

| This skill enables Claude to track and optimize application response times. It uses the response-time-tracker plugin to monitor API endpoints, database queries, external service calls, frontend rendering, and background job execution. The plugin calculates P50, P95, and P99 percentiles, average and maximum response times. Use this skill when you need to identify performance bottlenecks, monitor SLOs, or receive alerts about performance degradation. Trigger this skill with phrases like "track response times", "optimize latency", or "monitor application performance".

700 tokens
SQL Query Optimizer
ComeOnOliver

| Sql Query Optimizer - Auto-activating skill for Data Analytics. Part of the Data Analytics skill category.

314 tokens
Generating Stored Procedures
ComeOnOliver

| This skill uses the stored-procedure-generator plugin to create production-ready stored procedures, functions, triggers, and custom database logic. It supports PostgreSQL, MySQL, and SQL Server. Use this skill when the user asks to "generate stored procedure", "create database function", "write a trigger", or needs help with "database logic", "optimizing database performance", or "ensuring transaction safety" in their database. The skill is activated by requests related to database stored procedures, functions, or triggers.

766 tokens
Tracking Application Response Times
ComeOnOliver

Track and optimize application response times across API endpoints, database queries, and service calls. Use when monitoring performance or identifying bottlenecks. Trigger with phrases like "track response times", "monitor API performance", or "analyze latency".

1k tokens
Validating Database Integrity
ComeOnOliver

| Process use when you need to ensure database integrity through comprehensive data validation. This skill validates data types, ranges, formats, referential integrity, and business rules. Trigger with phrases like "validate database data", "implement data validation rules", "enforce data integrity constraints", or "validate data formats".

2k tokens
Azure Postgres Ts
ComeOnOliver
3k tokens
Azure Postgres
ComeOnOliver
1k tokens
Azure Resource Manager Mysql Dotnet
ComeOnOliver
3k tokens
Azure Resource Manager Postgresql Dotnet
ComeOnOliver
4k tokens
Azure Resource Manager Redis Dotnet
ComeOnOliver
3k tokens
Redis Development
ComeOnOliver
979 tokens
Database Admin
ComeOnOliver
2k tokens
Database Architect
ComeOnOliver
4k tokens
Database Cloud Optimization Cost Optimize
ComeOnOliver
381 tokens
Database Migration
ComeOnOliver
3k tokens
Database Migrations Migration Observability
ComeOnOliver
3k tokens
Database Migrations SQL Migrations
ComeOnOliver
494 tokens
Database Optimizer
ComeOnOliver
2k tokens
Vector Database Engineer
ComeOnOliver
498 tokens