sql-databases
CommunityMaster SQL and relational databases in prod
Data & Analytics#indexing#PostgreSQL#sql#partitioning#query-optimization#window-functions#relational-databases
Authorpluginagentmarketplace
Version1.0.0
Installs0
System Documentation
What problem does it solve?
SQL-databases skill solves production SQL performance problems by enabling efficient query design and optimization.
Core Features & Use Cases
- Query optimization & execution: Use EXPLAIN ANALYZE and indexing patterns to accelerate critical queries in production.
- Schema design & partitioning: Design normalized schemas and partition large data for scalability and reliability.
- Indexing patterns: Implement composite, partial, and functional indexes to support common workloads.
- Use Case: For dashboards with monthly aggregates, apply window functions and partitioning to speed up reports.
Quick Start
Start by connecting to a PostgreSQL 16+ or MySQL 8.0+ instance and applying the examples provided in this skill to optimize a representative workload.
Dependency Matrix
Required Modules
yaml
Components
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sql-databases Download link: https://github.com/pluginagentmarketplace/custom-plugin-data-engineer/archive/main.zip#sql-databases Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.