Skip to main content
subagent CX Codex

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

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/postgresql-pglite-pro.md
Open on GitHub

What 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 ANALYZE execution 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 ANALYZE output 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.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

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.

Similar subagents

All subagents for Data and databases →

From the same set112

The whole set →
parallel-tasks-help parallel-tasks-help is a Claude Code command that explains how to run /parallel-tasks, with its options, agent types, and examples. It also covers task systems and coordination stages. CX Codex +1 ★ 1,357repo stars linear-task-to-issue linear-task-to-issue exports Linear tasks into GitHub issues while preserving descriptions, child tasks, comments, and priority labels. CX Codex +1 ★ 1,357repo stars electron-pro A Claude subagent that runs an Electron project written in TypeScript: main and renderer processes, IPC through a preload bridge, packaging with electron-builder. CX Codex ★ 1,357repo stars skill-elicitation-agent skill-elicitation-agent interviews you about the skill you have in mind, then hands back a full Claude skill spec: examples, triggers, file layout and test cases. CX Codex ★ 1,357repo stars svelte-development svelte-development — a coding agent for Svelte 5+ and SvelteKit that can help shape components, routes, server-side data loading, and form handling. CX Codex ★ 1,357repo stars qa-expert qa-expert — a subagent for designing test strategies, executing comprehensive tests, tracking defects, and assessing product quality. Helps identify issues early, build confidence in releases, and deliver data-driven quality reports. CX Codex ★ 1,357repo stars integration-manager integration-manager coordinates bidirectional synchronization between GitHub issues and Linear tasks. Helpful when engineering workflows span across both issue trackers. CX Codex ★ 1,357repo stars WORKFLOW_EXAMPLES WORKFLOW_EXAMPLES — a workflow guide for coordinating Claude Command Suite agents across feature work, bug fixes, code audits, integrations, and releases. CX Codex ★ 1,357repo stars

Project sponsors

Companies that keep this analytics open