postgresql-pglite-pro — Claude Code subagent: setup and use
The postgresql-pglite-pro subagent for Claude Code models PostgreSQL schemas, tunes SQL with EXPLAIN, and configures browser-based Pglite with IndexedDB persistence.
no license ★ 1,357 updated 2026-03-01
.claude/agents/postgresql-pglite-pro.mdWhat postgresql-pglite-pro does
This subagent handles relational data architecture in PostgreSQL and client-side deployments with Pglite on WebAssembly. It prepares normalized schemas, formulates database migrations, and rewrites slow queries after inspecting EXPLAIN ANALYZE execution plans. Its coverage also includes PostGIS spatial queries, JSONB structures, and window functions.
For web applications, the subagent implements Pglite storage using IndexedDB and configures reactive queries for front-end rendering. Running this agent requires active context7 and sequential-thinking MCP servers in your environment; without those tools, it cannot perform deep reasoning chains or query documentation directly.
What it helps with
- Optimize slow queries by evaluating
EXPLAIN ANALYZEexecution paths - Design relational schemas with appropriate table constraints and indexes
- Embed Pglite into browser applications with IndexedDB persistence
- Structure database migration scripts and JSONB queries
Example prompts for the agent
- Analyze this
EXPLAIN ANALYZEoutput and propose indexing adjustments for our orders table. - Set up Pglite inside a React web app with persistent storage via IndexedDB.
- Design a relational schema for product listings with attributes stored in JSONB.
How to install postgresql-pglite-pro
Manually: put the files in place
.claude/agents/postgresql-pglite-pro.mdFor all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention
Manually: put the files in place
.codex/agents/postgresql-pglite-pro.tomlCodex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/
Manually: put the files in place
.cursor/agents/postgresql-pglite-pro.mdCursor also reads .claude/agents/
Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean
Questions about postgresql-pglite-pro
How to install postgresql-pglite-pro in Claude Code?
Save the subagent configuration file to .claude/agents/postgresql-pglite-pro.md inside your project directory.
What does postgresql-pglite-pro do?
It designs PostgreSQL relational schemas, diagnoses slow queries using execution plans, and sets up in-browser Pglite instances.
Which MCP tools does this agent require?
It depends on context7 for retrieving reference documentation and sequential-thinking for step-by-step query optimization and architecture decisions.