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
- Repository
- jeremylongshore/tons-of-skills-marketplace
- 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
- 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.
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.
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
- Dataset Splitter Split datasets for training, validation, and testing Plugin · jeremylongshore/tons-of-skills-marketplace
- Databricks Workspace Mcp MCP server for the Databricks control plane — 8 read-only tools for cluster forensics, instance pools, DLT pipeline event logs, and Unity Catalog external locations / storage credentials. The endpoint families no managed Databricks MCP exposes; pairs with the managed SQL MCP for system.* reads. Plugin · jeremylongshore/tons-of-skills-marketplace
- Db Diff Compare database schemas and generate safe migration scripts with rollback Slash Command · jeremylongshore/tons-of-skills-marketplace
- Dead Code Hunter Scans for unused exports, dead imports, unreachable code, and stale feature flags using knip/vulture/deadcode, auto-removes high-confidence findings after build verification, and flags the rest for manual review. Use when cleaning up a codebase before a refactor or release. Trigger with "find dead code", "remove unused exports". Subagent · jeremylongshore/tons-of-skills-marketplace
- Geepers Deps Audits project dependencies for CVEs, outdated packages, and license compatibility using pip-audit, npm audit, and pip-licenses/license-checker. Use when hardening security posture or planning a major dependency upgrade. Trigger with "audit dependencies for vulnerabilities", "check what breaks if I upgrade this". Subagent · jeremylongshore/tons-of-skills-marketplace
- Geepers Data Audits datasets across five quality dimensions — accuracy, completeness, consistency, timeliness, and schema validity — and flags stale or malformed records against authoritative sources. Use when updating a dataset or when data feels outdated. Trigger with "audit this dataset", "check data freshness". Subagent · jeremylongshore/tons-of-skills-marketplace
- Geepers Design Applies Swiss/International Style principles — grid systems, typographic scales, 8px spacing, and WCAG AA contrast — to create clean, functional interface designs and design system recommendations. Use when building a new component or auditing a page's visual consistency. Trigger with "review the design system", "design this component". Subagent · jeremylongshore/tons-of-skills-marketplace
- Geepers Dashboard Synchronizes admin dashboards, registers new services for persistence via service_manager.py, and verifies all dashboards reflect accurate system state after reboots. Use when adding a new service or verifying the system after a restart. Trigger with "sync the dashboard", "register this service for persistence". Subagent · jeremylongshore/tons-of-skills-marketplace