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 ★
LLM Redteam — LLM red-team corpus runner — fires categorized prompt-injection / jailbreak / system-prompt-leak / data-exfil 4.5k ★
06 Ink React Terminal UI — Prompt 06: Verify and Fix the Ink/React Terminal UI Pipeline 2.3k ★

Full documentation available on GitHub

View Source Repository