skills.rest
m16khb
m16khbCOMMUNITY
Explore all skills by this author →
GitHub

codd

Analyze and optimize relational database schemas and SQL queries.

1|Updated Jun 4, 2026
Search Tags:#schema design#performance tuning#query analysis#database optimization#relational database
One-click install
npx skills add https://github.com/m16khb/agent-harness --skill codd
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: codd
Source: https://github.com/m16khb/agent-harness/tree/main/skills/codd
Command: npx skills add https://github.com/m16khb/agent-harness --skill codd

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides expert guidance for relational database schema design and query optimization, helping to enhance performance and maintain data integrity.

Core Features & Use Cases

  • Schema Design: Offers advice on normalization, indexing, and partitioning strategies.
  • Query Optimization: Analyzes and improves SQL query performance using EXPLAIN ANALYZE.
  • Use Case: When faced with slow queries or database performance issues, Codd can help identify the root cause and suggest improvements.

Quick Start

Use the codd skill to analyze the performance of your SQL query and provide optimization recommendations.

Frequently Asked Questions about codd

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow SQL queries using EXPLAIN ANALYZE?▼

To optimize slow SQL queries using EXPLAIN ANALYZE, execute the query plan to identify bottlenecks like full table scans. This Skill analyzes the execution plan and suggests indexing or query restructuring improvements to enhance performance.

What is the best way to design a relational database schema for performance?▼

The best way to design a relational database schema for performance involves applying normalization, indexing, and partitioning strategies. This Skill provides expert schema design guidance to maintain data integrity and optimize query execution.

Do I need a live database connection to analyze SQL query performance?▼

Yes, you need a live database connection to analyze SQL query performance. This Skill requires access to a relational database and a SQL query execution environment to run EXPLAIN ANALYZE and evaluate execution plans.

When should I use database partitioning for schema optimization?▼

You should use database partitioning for schema optimization when managing large tables that cause slow query performance. This Skill offers partitioning strategies alongside normalization and indexing to improve database performance.

Why does my relational database query perform a full table scan?▼

Your relational database query performs a full table scan due to missing indexes or unoptimized schema design. This Skill analyzes your SQL queries and schema to identify the root cause and suggest indexing improvements.

Related Skills

Explore More Software Engineering Skills→
v1bh0rv1bh0r

nw-query-optimization

Analyze execution plans and design indexes for SQL and NoSQL queries.

Community
Intermediate
codeApe-7codeApe-7
17

sql-pro

Analyze SQL execution plans and suggest indexing strategies.

Community
Advanced
udecodeudecode
240

data-integrity-guardian

Review database migrations, data models, and persistent data code for safety and integrity.

Official
Advanced
rodmena-limitedrodmena-limited
3

moai-domain-database

Provide database schema design, query optimization, and indexing strategies.

Official
Advanced