ils15

Optimize Database.Prompt — Data skill for Claude Code

Data community

Analyze and optimize database schema, queries, and performance.

How to install Optimize Database.Prompt

Installs to ~/.claude/skills/ils15-pantheon-legacy-optimize-database.prompt/SKILL.md

Terminal

mkdir -p ~/.claude/skills/ils15-pantheon-legacy-optimize-database.prompt && curl -fsSL https://raw.githubusercontent.com/ils15/pantheon-legacy/HEAD/prompts/optimize-database.prompt.md -o ~/.claude/skills/ils15-pantheon-legacy-optimize-database.prompt/SKILL.md

Restart Claude Code, or start a new session, for it to be picked up.

What Optimize Database.Prompt does

name: optimize-database description: "Analyze and optimize database schema, queries, and performance" agent: demeter tools: ['search', 'usages']

Optimize Database (Demeter)

Performance Analysis

Query Optimization

Identify N+1 queries
Analyse query plans (EXPLAIN)
Suggest strategic indexes
Optimise JOINs
Batch operations when possible

Index Strategy

Indexes on WHERE columns
Indexes on JOIN columns
Indexes on ORDER BY columns
Composite indexes when approp

Alternatives in Data

SQL Queries — Generate SQL queries from natural language across major dialects 7.8k ★
Aoci Code — Local-first MCP server + CLI in Go: a persistent, governed codebase index that distills code and database sche 443 ★
Core Data Agent Skill — An Agent Skill focused on Apple’s Core Data framework, helping with data modeling, fetch requests, performance 301 ★

Full documentation available on GitHub

View Source Repository