Sponsor Suno AI Music arrow_forward
Subagent

Geepers Db

Analyzes query plans, recommends indexes, and diagnoses N+1 patterns, lock contention, and missing pagination for SQLite and PostgreSQL databases. Use when a search endpoint is slow or the database shows signs of needing to scale. Trigger with "analyze slow queries", "optimize the database".

Type
Subagent
GitHub stars
2.8k
License
MIT
Repo last updated
Sep 27, 2026
Model
sonnet
Version
1.0.0
Author
Jeremy Longshore <[email protected]>

What Geepers Db is

Geepers Db is a subagent published in the jeremylongshore/tons-of-skills-marketplace repository on GitHub, which has about 2.8k stars. The repository describes itself as: “Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com.”

A subagent is a specialist assistant that Claude can hand part of a task to. It is a markdown file whose frontmatter sets a name, a description that tells Claude when to delegate, and optionally the tools and model it may use; the body becomes the subagent's own system prompt.

Because a subagent works in its own context, it keeps the main conversation focused: Claude can send a narrow job, such as a review or a specialised analysis, to Geepers Db and get back a compact result.

How to install Geepers Db

Claude Code

  1. Download geepers_db.md from the repository.
  2. Save it to ~/.claude/agents/ to use it in every project, or to .claude/agents/ inside one project to share it through version control.
  3. Claude Code watches these folders, so the subagent is usually available right away. Ask Claude to use it by name, or @-mention it to make sure it runs.

Claude Cowork

  1. Cowork loads subagents through plugins. If the repository is packaged as a plugin marketplace, add it under Customize → Plugins → Add marketplace and install the plugin that contains this subagent.
  2. Otherwise, bundle the file into your own plugin's agents/ folder and upload it from Customize → Plugins.

New to extending Cowork? Our plugins guide and Customize guide explain how skills, plugins, and connectors fit together.

Inside the source file

An excerpt from plugins/community/geepers-agents/agents/geepers_db.md, shared under the repository's MIT license. Read the full file on GitHub.

Examples

Example 1

Context: Slow queries user: "The search endpoint is slow, I think it's the database" assistant: "Let me use geepers_db to analyze query performance."

Example 2

Context: Database planning user: "How is our database performing? Do we need to scale?" assistant: "I'll use geepers_db for capacity analysis."

Mission

You are the Database Optimizer - analyzing queries, recommending indexes, and ensuring database performance meets application needs.

Output Locations

  • Reports: ~/geepers/reports/by-date/YYYY-MM-DD/db-{project}.md
  • Recommendations: Append to ~/geepers/recommendations/by-project/{project}.md

Analysis Tools

SQLite

-- Query plan
EXPLAIN QUERY PLAN SELECT * FROM table WHERE condition;

-- Database stats
SELECT * FROM sqlite_master;

-- Table info
PRAGMA table_info(table_name);

-- Index list
PRAGMA index_list(table_name);

PostgreSQL

-- Query plan
EXPLAIN ANALYZE SELECT ...;

-- Index usage
SELECT schemaname, tablename, indexname, idx_scan
FROM pg_stat_user_indexes;

-- Table sizes
SELECT relname, pg_size_pretty(pg_total_relation_size(relid))
FROM pg_stat_user_tables;

Optimization Checklist

  • Indexes on frequently queried columns
  • Indexes on foreign keys
  • No redundant indexes
  • Proper index types (B-tree, GIN, etc.)
  • Query uses indexes (not full table scans)
  • Connection pooling configured
  • Appropriate transaction isolation

Common Issues

Coordination Protocol

Delegates to:

  • geepers_perf: For application-level profiling

Called by:

  • geepers_perf: When database bottleneck suspected
  • Manual invocation

Shares data with:

  • geepers_status: Database health metrics

Before you install

  • Read the whole file first. Skills, commands, and subagents are instructions Claude will follow, so make sure they match what you want.
  • Check which tools, scripts, or MCP servers it uses. Local servers and scripts run with your permissions.
  • Try it in a test project or a copy of your files before pointing it at real work.
  • Pin the version you tested, and review changes before updating.
  • Watch for instructions that fetch web content or run shell commands; those are where prompt injection risks start. See our prompt injection guide.

FAQ

What is Geepers Db?

Geepers Db is a subagent for Claude Code and Claude Cowork from the jeremylongshore/tons-of-skills-marketplace repository on GitHub. Analyzes query plans, recommends indexes, and diagnoses N+1 patterns, lock contention, and missing pagination for SQLite and PostgreSQL databases. Use when a search endpoint is slow or the database shows signs of needing to scale. Trigger with "analyze slow queries", "optimize the database".

How do I install Geepers Db in Claude Code?

Download geepers_db.md from the repository. Save it to ~/.claude/agents/ to use it in every project, or to .claude/agents/ inside one project to share it through version control. Claude Code watches these folders, so the subagent is usually available right away. Ask Claude to use it by name, or @-mention it to make sure it runs.

Can I use Geepers Db in Claude Cowork?

Cowork loads subagents through plugins. If the repository is packaged as a plugin marketplace, add it under Customize → Plugins → Add marketplace and install the plugin that contains this subagent. Otherwise, bundle the file into your own plugin's agents/ folder and upload it from Customize → Plugins.

Is Geepers Db safe to install?

It is a third-party community resource, not reviewed by Anthropic or this site. Read the source file first, check which tools and connectors it uses, and install only from sources you trust.

Similar resources

Browse all skills, subagents, and plugins →

Listing data comes from the public GitHub repository and was last checked in September 2026. Excerpts are © their authors and shared under MIT. This directory is independent and not affiliated with Anthropic or the resource's authors.