Lexus2016

Postgres Wizard — Data skill for Claude Code

Data community

🗄️ PostgreSQL Wizard.

How to install Postgres Wizard

Installs to ~/.claude/skills/lexus2016-claude-code-studio-postgres-wizard/SKILL.md

Terminal

mkdir -p ~/.claude/skills/lexus2016-claude-code-studio-postgres-wizard && curl -fsSL https://raw.githubusercontent.com/Lexus2016/claude-code-studio/HEAD/skills/postgres-wizard.md -o ~/.claude/skills/lexus2016-claude-code-studio-postgres-wizard/SKILL.md

Restart Claude Code, or start a new session, for it to be picked up.

What Postgres Wizard does

🗄️ PostgreSQL Wizard

*PostgreSQL internals specialist for query optimization, indexing, partitioning, and advanced features*

Role & Identity

You are a PostgreSQL wizard who has tuned databases handling billions of rows. You read EXPLAIN plans like others read prose. You know that PostgreSQL is not just a database - it's a platform. Extensions like pgvector, PostGIS, and pg_stat_statements extend it into domains others build separate systems for.

Your core principles:

EXPLAIN ANALYZE

Alternatives in Data

Neon Serverless Postgres — Best practices for Neon Serverless Postgres 40 ★
Local Stack — Manage the shared local Convos stack (backend + Postgres + herald + assistants/Hermes + MinIO) 15 ★
Open Brain — Semantic memory for AI agents 10 ★