Can this skill help me fix slow database queries?

Yes, it provides tools for running EXPLAIN ANALYZE, identifying missing indexes, and suggesting query refactoring to eliminate full table scans and OOM errors.

Is it capable of generating production-ready code?

Yes, it generates standardized SQL DDL, NoSQL schemas, and Python/Node.js integration code following industry best practices for security and performance.

Which databases are supported by this skill?

The skill supports a wide range of databases including relational systems like PostgreSQL and MySQL, document stores like MongoDB, key-value stores like Redis, and wide-column stores like Cassandra.

Does it provide guidance on choosing between SQL and NoSQL?

Absolutely. It includes a decision tree that analyzes your requirements for ACID transactions, data types, and scaling needs to recommend the best database for your project.

Database Management

Name: Database Management
Author: pluginagentmarketplace

bypluginagentmarketplace

•

Database Management

Architects, optimizes, and manages relational and NoSQL databases to ensure high performance, data integrity, and scalability.

About

The Database Management skill empowers Claude to handle the entire database lifecycle, from initial technology selection and schema design to advanced query optimization and troubleshooting. Supporting a diverse range of technologies including PostgreSQL, MySQL, MongoDB, Redis, and Cassandra, it provides production-grade guidance on ACID compliance, indexing strategies, and caching patterns. Whether you are building an e-commerce backend from scratch or refactoring slow-running queries in a legacy system, this skill offers the specialized tools and decision frameworks needed for robust data persistence and optimization.

Key Features

Multi-Database Support (PostgreSQL, MySQL, MongoDB, Redis, Cassandra, Elasticsearch)
1 GitHub stars
Database Selection Decision Frameworks
Automated Schema Design and Data Modeling
Operations Management (Backups, Migrations, and Scaling)
Query Performance Analysis and Indexing Optimization

Use Cases

Designing production-ready schemas for complex e-commerce or SaaS applications
Optimizing slow SQL queries using execution plan analysis and index creation
Implementing Redis caching layers to improve application response times

About

Key Features

Multi-Database Support (PostgreSQL, MySQL, MongoDB, Redis, Cassandra, Elasticsearch)
1 GitHub stars
Database Selection Decision Frameworks
Automated Schema Design and Data Modeling
Operations Management (Backups, Migrations, and Scaling)
Query Performance Analysis and Indexing Optimization

Use Cases

Designing production-ready schemas for complex e-commerce or SaaS applications
Optimizing slow SQL queries using execution plan analysis and index creation
Implementing Redis caching layers to improve application response times