Technology & Engineering19 skills

Database Engineering skills for AI agents

19 practitioner-grade database engineering skills, each a focused Markdown document your agent loads into context on demand. Search them from Claude Desktop, Cursor or any MCP client, or pull one with the CLI.

$ npx skilldb search "database engineering"

All 19 skills

Backup Recovery
Master the strategies and techniques for safeguarding database integrity and ensuring business continuity through robust backup and recovery plans. Activate this skill when designing disaster recovery protocols, responding to data loss incidents, planning major system migrations, or optimizing data resilience for critical applications.
77 lines
Caching Strategies
Implement and manage various caching strategies to reduce database load, improve application response times, and enhance scalability. Activate this skill when encountering high database latency, excessive database queries, slow user interfaces, or when optimizing for read-heavy workloads and cost efficiency.
76 lines
Connection Pooling
Configure and manage database connection pools to maximize throughput, minimize latency, and prevent resource exhaustion. Activate this skill when applications experience connection timeouts, database "too many connections" errors, high connection churn, or when tuning application-to-database resource utilization.
173 lines
Data Modeling
Design and structure data for databases to ensure integrity, optimize performance, and support business logic effectively. Activate this skill when initiating new database projects, refactoring existing schemas, troubleshooting data consistency issues, or when planning for future application scalability and data evolution.
83 lines
Database Security
Harden database systems against unauthorized access, data breaches, and service disruption by implementing robust security controls. Activate this skill when designing new data infrastructure, auditing existing systems, responding to security incidents, or establishing a comprehensive data governance framework.
67 lines
Full Text Search
Implement and optimize full-text search capabilities in databases to provide fast, relevant, and natural language-aware retrieval of information. Activate this skill when simple `LIKE` queries are insufficient for search accuracy, performance, or when dealing with large volumes of text data requiring nuanced relevance ranking and language processing.
92 lines
Graph Databases
Design, implement, and query graph databases to effectively model and analyze highly connected data. Activate this skill when your data's relationships are as important as the data itself, requiring complex traversals, pathfinding, or network analysis that is cumbersome in relational systems.
84 lines
Indexing Strategies
Optimize database query performance by understanding, designing, and implementing effective indexing strategies. Activate this skill when encountering slow queries, designing new database tables, or performing database refactoring for performance enhancements.
89 lines
Migrations
Manage database schema and data changes in a controlled, versioned, and reversible manner. Activate this skill when evolving database schemas, deploying new features, refactoring existing data structures, or ensuring consistency across development, staging, and production environments.
98 lines
Nosql Patterns
Strategize and apply effective data modeling and access patterns for non-relational databases. Activate this skill when designing scalable, high-performance applications with flexible data requirements, or when optimizing existing NoSQL data stores for specific use cases like analytics, caching, or real-time processing.
85 lines
ORM Patterns
Apply common Object-Relational Mapping (ORM) patterns to efficiently interact with databases, maintain data integrity, and boost developer productivity. Activate this skill when designing data access layers, optimizing database interactions, debugging ORM-related performance issues, or seeking to balance abstraction with control.
85 lines
Query Performance
Identify, diagnose, and optimize slow database queries to improve application responsiveness and reduce database load. Activate this skill when encountering high database CPU utilization, slow application features, specific query timeouts, or general database sluggishness.
76 lines
Replication Patterns
Architect and manage database replication topologies to achieve high availability, disaster recovery, and read scalability. Activate this skill when designing fault-tolerant database systems, scaling read-heavy workloads, setting up cross-region deployments, or troubleshooting replication lag and consistency issues.
170 lines
Replication
Implement and manage database replication strategies to ensure high availability, disaster recovery, and read scalability for your data systems. Activate this skill when designing resilient architectures, planning for data redundancy, scaling read-heavy applications, or migrating data across environments.
91 lines
Schema Design
Architect and refine database schemas to ensure data integrity, optimize query performance, and support application scalability. Activate this skill when initiating new database development, refactoring existing data models, or addressing persistent performance issues rooted in data structure.
82 lines
Sharding Strategies
Design and implement horizontal database sharding to distribute data across multiple nodes for improved scalability, throughput, and fault isolation. Activate this skill when a single database instance can no longer handle the workload, when planning for massive data growth, or when architecting globally distributed data systems.
139 lines
Sharding
Distribute a single logical database across multiple physical database instances to achieve horizontal scalability, improve performance, and enhance fault tolerance. Activate this skill when a monolithic database reaches its vertical scaling limits, experiences severe I/O bottlenecks, or requires increased read/write throughput beyond what a single server can provide.
89 lines
SQL Optimization
Identify, analyze, and rewrite inefficient SQL queries to improve database performance, reduce resource consumption, and enhance application responsiveness. Activate this skill when encountering slow database operations, high CPU/IO usage from the database, or when optimizing application features that rely heavily on data retrieval.
72 lines
Time Series Data
Design, implement, and manage databases optimized for time-series data, characterized by high-volume, time-stamped events. Activate this skill when dealing with IoT sensor data, financial tick data, application metrics, monitoring logs, or any dataset where time is the primary dimension for analysis and retrieval.
77 lines