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

•

数据库管理

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

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.

主要功能

01Query optimization patterns and EXPLAIN plan analysis

02Advanced indexing strategies including B-tree, GIN, and BRIN

031 GitHub stars

04SQL vs NoSQL selection matrix for specialized workloads

05Automated schema validation for normalization and performance

06Capacity estimation and data growth projection tools

使用场景

01Designing a high-concurrency OLTP schema for transactional web apps

02Architecting distributed NoSQL data models for global applications

03Optimizing analytical query performance in large-scale data warehouses

主要功能

01Query optimization patterns and EXPLAIN plan analysis

02Advanced indexing strategies including B-tree, GIN, and BRIN

031 GitHub stars

04SQL vs NoSQL selection matrix for specialized workloads

05Automated schema validation for normalization and performance

06Capacity estimation and data growth projection tools

使用场景

01Designing a high-concurrency OLTP schema for transactional web apps

02Architecting distributed NoSQL data models for global applications

03Optimizing analytical query performance in large-scale data warehouses