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
Analyze Solidity and other smart contract code for security vulnerabilities, gas inefficiencies, and best practice violations. Get detailed reports with risk scoring, remediation suggestions, and optimization recommendations. Whether you're auditing before deployment or reviewing third-party contracts, this skill identifies critical issues faster than manual review.
You can systematically diagnose database performance bottlenecks by sharing your schema, slow query logs, and execution plans with Claude. It identifies root causes—missing indexes, inefficient joins, lock contention—and provides prioritized recommendations with ready-to-implement SQL. Skip the manual log analysis and get tuning strategies tailored to your workload.
This skill provides a structured approach to analyzing process problems, identifying root causes, and recommending capacity optimizations. You'll get clear bottleneck identification, data-driven recommendations, and a framework to validate whether your solutions actually work. Perfect for diagnosing why workflows are slow and finding the leverage points that matter most.
Use Claude to systematically analyze your database queries, execution plans, and schema to identify performance bottlenecks. The skill generates actionable optimization recommendations with SQL rewrites, index strategies, and configuration tuning. You'll receive detailed before-and-after performance analysis to validate improvements and prioritize work by impact.
You'll develop systematic approaches to injectable formulation design, from API selection through sterilization strategy. Claude helps you troubleshoot failed batches by analyzing root causes, recommends regulatory pathways (505(b)(2), ANDA, NDA), and provides science-backed solutions for stability, compatibility, and manufacturability challenges.
You'll design and implement mobile features with architectural rigor, cross-platform considerations, and edge-case handling built-in. This skill generates complete system designs, platform-specific implementation strategies, performance optimization approaches, and testing frameworks. The output is production-ready guidance spanning iOS and Android with security, offline resilience, and deployment strategies included.
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 can architect multi-node ROS control systems from scratch, including node design patterns, communication flows, and real-time constraints. You'll debug complex node interactions using publisher/subscriber analysis, service call tracing, and action server diagnostics. You can optimize motion controllers through PID tuning, trajectory planning validation, and performance profiling to achieve precise, responsive robotic behavior.