Databases
Design, optimize, and manage MongoDB and PostgreSQL databases
What You Can Do
You can design database schemas optimized for your data model, write and debug complex SQL queries and MongoDB aggregation pipelines, optimize indexes and query performance, execute database migrations safely, configure replication and sharding for scale, implement backup and disaster recovery strategies, manage user permissions and access control, and troubleshoot performance issues in production environments. This skill helps you choose the right database for your use case and master both relational and document-oriented paradigms.
Features
Example Output
Schema Design Example:
PostgreSQL: CREATE TABLE users with normalized structure, foreign keys, and constraints for strict integrity
MongoDB: Design flexible document structure with embedded or referenced relationships based on query patterns
Query Optimization Example:
Before: SELECT * FROM orders WHERE status = 'pending' (sequential scan, slow)
After: CREATE INDEX idx_orders_status; results in index scan 10x faster
Migration Example:
Version 1: Add new column with backward-compatible default
Version 2: Populate existing rows in background transaction
Version 3: Add NOT NULL constraint after data migration complete
What's Included
- SKILL.md instruction file with when-to-use triggers and database selection guide:
- PostgreSQL schema design templates with ACID patterns and referential integrity examples:
- MongoDB document model patterns with aggregation pipeline frameworks:
- Query optimization checklist covering indexes, explain plans, and performance analysis:
- Database migration workflow with rollback procedures and data validation steps:
- Backup and disaster recovery configuration templates for both databases:
- Production deployment checklist for replication, sharding, and monitoring setup:
Who It's For
- Database Administrators managing production PostgreSQL or MongoDB deployments
- Backend Engineers designing data models and optimizing queries
- DevOps Engineers configuring replication, backups, and disaster recovery
- Data Engineers building ETL pipelines and managing data migrations
- Solutions Architects evaluating and recommending the right database for projects
Best For
- Designing normalized relational schemas or flexible document models
- Writing and debugging SQL queries with complex joins and aggregations
- Optimizing slow queries through indexing and query plan analysis
- Planning and executing zero-downtime database migrations
- Setting up production replication and sharding for scalability
- Implementing comprehensive backup, restore, and disaster recovery strategies
- Managing database user permissions and role-based access control
You might also like
You can accelerate your entire antenna design workflow—from initial concept to optimized specifications—by leveraging Claude's knowledge of electromagnetic theory, antenna types, and design trade-offs. Claude helps you parameterize designs, identify optimal configurations for your frequency band and application, and prepare detailed briefs for simulation and manufacturing. You'll generate design reviews, impedance-matching solutions, and validation checklists without context-switching to multiple tools.
You can convert raw API code, OpenAPI specs, GraphQL schemas, and implementation details into production-ready reference documentation. The skill generates systematically organized endpoint documentation with parameter tables, real request/response examples, error code catalogs, authentication details, rate limits, and SDK usage snippets in multiple programming languages—creating the authoritative developer reference for REST APIs, GraphQL APIs, WebSocket APIs, and webhook schemas.
Rapidly analyze production incidents by correlating observability signals—logs, metrics, traces, and events—to identify the true root cause instead of symptoms. You'll reconstruct incident timelines, quantify impact scope, and generate both immediate remediation steps and long-term prevention measures.
This skill guides you through designing Kalman filters for your specific state estimation and sensor fusion problems. You'll learn to diagnose filter divergence, tune covariance matrices (Q and R), and validate observability—turning mathematical theory into production-ready filters. The skill provides step-by-step workflows, diagnostic tools, and practical templates for common applications like GPS/IMU fusion, SLAM, and aircraft navigation.
Claude analyzes your code diffs and generates standardized commit messages that follow the Conventional Commits specification. The skill automatically determines the correct commit type, scope, and description based on the changes you've made, ensuring your messages are parseable by automation tools while remaining human-readable for code reviewers.
You'll transform high-level feature requirements into a complete development plan covering API design, frontend implementation, testing strategy, and documentation. The skill helps you identify dependencies, parallelize work across frontend and backend teams, and establish quality gates that ensure features ship bug-free with proper error handling and logging.
You get a comprehensive security and gas optimization review of your Solidity smart contracts. The skill identifies common vulnerabilities like reentrancy attacks, overflow/underflow bugs, and unchecked external calls, while also pinpointing expensive operations and suggesting specific gas optimizations. Use this as a pre-audit screening to catch issues early and prepare your code for professional security review.
You can rapidly design, optimize, and validate chromatographic and LC-MS/MS methods for analyzing drugs and metabolites in biological matrices. This skill guides you through analytical method development workflows—including parameter selection, sensitivity optimization, and regulatory strategy—while ensuring ICH Q2(R2) and FDA compliance throughout the development process.