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 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.
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.
This skill evaluates your research protocols against institutional review board requirements, identifies compliance gaps, and generates the documentation needed for IRB submission. You receive a detailed assessment report, risk analysis, and ready-to-use documentation templates tailored to your specific research design.
You can systematically evaluate cloud platforms, document architectural decisions with tradeoffs, and validate designs against security and compliance requirements. This skill accelerates architecture reviews, ensures consistency across teams, and reduces the cycles needed to reach approval on complex infrastructure decisions.
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.
Design and optimize injectable formulations by analyzing your active pharmaceutical ingredient (API), selecting compatible excipients, and predicting stability outcomes. You'll receive systematic workflows that guide you through API characterization, formulation architecture, and risk mitigation—enabling faster development cycles and regulatory-ready documentation.
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.
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.