Does it support performance tuning for existing queries?

Absolutely. The skill provides frameworks for analyzing EXPLAIN plans, suggesting composite indexes, and identifying common bottlenecks like sequential scans or lock contention.

Can this skill help choose between SQL and NoSQL?

Yes, it includes a comprehensive selection matrix comparing PostgreSQL, MySQL, CockroachDB, MongoDB, Cassandra, and more based on your specific volume, velocity, and consistency requirements.

What database types are covered by this skill?

The skill covers a wide range of architectures including Transactional (OLTP), Analytical (OLAP), Time-series, Document stores, and Graph databases.

Can it help with database capacity planning?

Yes, it features unit test templates and logic for estimating current and projected storage sizes based on row density and monthly growth rates.

Database Design Architect

Name: Database Design Architect
Author: pluginagentmarketplace

bypluginagentmarketplace

•

Database Management

Architects production-grade SQL and NoSQL databases with automated schema validation and performance optimization patterns.

About

The Database Design skill enables Claude to provide expert-level guidance on data storage patterns, ranging from traditional ACID-compliant SQL databases to high-scale NoSQL systems. It automates the selection process based on specific use cases like OLTP and OLAP, validates schema designs against industry best practices, and offers detailed indexing strategies to minimize latency. Whether you are building a new system from scratch or troubleshooting a slow production database, this skill provides the structured logic, validation rules, and capacity planning needed for robust, scalable data architecture.

Key Features

Query optimization patterns and EXPLAIN plan analysis
Advanced indexing strategies including B-tree, GIN, and BRIN
1 GitHub stars
SQL vs NoSQL selection matrix for specialized workloads
Automated schema validation for normalization and performance
Capacity estimation and data growth projection tools

Use Cases

Designing a high-concurrency OLTP schema for transactional web apps
Architecting distributed NoSQL data models for global applications
Optimizing analytical query performance in large-scale data warehouses

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add pluginagentmarketplace/custom-plugin-system-design database-design

For use in Claude.ai and ChatGPT

Download Skill

GitHub