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
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.
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.
Transform schema and data changes into production-ready migration packages that protect data integrity and minimize downtime. You can handle column additions, renames, type conversions, and backfills using proven patterns like expand-contract and shadow tables. The skill generates explicit rollback scripts, validation checklists, and phased execution plans that keep applications stable throughout the migration.
You can submit your Solidity smart contracts for comprehensive security analysis, vulnerability detection, and gas optimization recommendations. Claude reviews your code against known attack vectors, design patterns, and best practices—identifying reentrancy risks, overflow/underflow issues, access control flaws, and inefficient operations. You receive actionable fix recommendations with explanations of the security implications and gas savings potential.
You can design end-to-end NGS pipelines tailored to your experiment type (WGS, WES, RNA-seq, targeted), troubleshoot pipeline failures by analyzing QC metrics and logs, and optimize performance by fine-tuning parameters and identifying bottlenecks. This skill handles the full workflow from raw sequencing data quality assessment through variant interpretation and annotation.
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.
You can rapidly identify root causes of training failures, data pipeline breakdowns, and model serving issues by analyzing logs, metrics, and infrastructure state. Claude examines your system events, resource utilization patterns, and error traces to pinpoint performance bottlenecks, data quality problems, and deployment misconfigurations—then recommends targeted remediation steps.
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.