Postgresql Specialist
Ultra-specialized PostgreSQL 16+ expert covering advanced database administration, query optimization, schema design, performance tuning, high availability, security, and modern PostgreSQL features including JSONB, logical replication, parallel processing, and enterprise-grade patterns for 2025 production environments.
- Type
- Subagent
- Repository
- ChrisRoyse/610ClaudeSubagents
- GitHub stars
- 117
- License
- Not declared
- Repo last updated
- Aug 10, 2025
- Source file
- agents/postgresql-specialist.md
What Postgresql Specialist is
Postgresql Specialist is a subagent published in the ChrisRoyse/610ClaudeSubagents repository on GitHub, which has about 117 stars.
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 Postgresql Specialist and get back a compact result.
It is set up to use these tools: Read, Write, Edit, MultiEdit, Grep, Glob, Bash. Limiting tools is a good sign: the subagent can only do what those tools allow.
How to install Postgresql Specialist
Claude Code
- Download postgresql-specialist.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
The repository does not declare an open-source license, so we list only the outline of the file here. Read the full text on GitHub.
- ALWAYS CLOSELY INSPECT THE RESULTS OF SUBAGENTS AND MAKE SURE THEY AREN'T LIEING AND BEING HONEST AND TRUTHFUL.
- PostgreSQL 17+ Core Features (2025)
- JSONB & Semi-Structured Data Mastery
- Advanced Query Optimization (2025)
- Index Architecture & Strategies (2025)
- Advanced Schema Design (2025)
- PL/pgSQL Advanced Programming (2025)
- Performance Tuning Excellence (2025)
- High Availability & Replication (2025)
- Security & Compliance (2025)
- Full-Text Search Excellence (2025)
- Advanced Data Types & Operations (2025)
- Database Administration Excellence (2025)
- Time-Series & Analytics (2025)
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 Postgresql Specialist?
Postgresql Specialist is a subagent for Claude Code and Claude Cowork from the ChrisRoyse/610ClaudeSubagents repository on GitHub. Ultra-specialized PostgreSQL 16+ expert covering advanced database administration, query optimization, schema design, performance tuning, high availability, security, and modern PostgreSQL features including JSONB, logical replication, parallel processing, and enterprise-grade patterns for 2025 production environments.
How do I install Postgresql Specialist in Claude Code?
Download postgresql-specialist.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 Postgresql Specialist 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 Postgresql Specialist 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
- Policy Compliance Enforcement Expert in checking containers and runtime for security and compliance baselines (NIST/PCI/DISA/OWASP). Use for automated policy enforcement and comprehensive compliance validation. Subagent · ChrisRoyse/610ClaudeSubagents
- Plugin Extension Writer Agent Creates plug-ins, browser extensions, IDE integrations, and SDK modules. Expert in extensible architectures, plugin systems, and modular development patterns. Subagent · ChrisRoyse/610ClaudeSubagents
- Political Sentiment Tracking Agent Monitors and analyzes public political sentiment using verified social media analytics, polling data, and news sentiment analysis with bias detection and trend forecasting capabilities Subagent · ChrisRoyse/610ClaudeSubagents
- Postmortem Devils Advocate Expert in reconstructing what "could have gone wrong" and critiquing retrospective analyses for glossed-over failures or inadequate learnings. Challenges postmortem conclusions and pushes for deeper root cause analysis. Subagent · ChrisRoyse/610ClaudeSubagents
- Population Dynamics Forecasting Agent Predicts demographic changes, migration patterns, and population distributions using verified census data, migration tracking, and demographic modeling with statistical validation and uncertainty quantification Subagent · ChrisRoyse/610ClaudeSubagents
- Prd Generator Agent Expert in creating comprehensive Product Requirements Documents (PRDs) with AI integration, user stories, technical feasibility, and success metrics. Use for complete PRD generation and enhancement. Subagent · ChrisRoyse/610ClaudeSubagents
- Preact Specialist Ultra-specialized Preact 10.x+ framework expert with comprehensive knowledge of 3kB React alternative, preact/compat ecosystem, Signals reactivity, performance optimization, and production deployment patterns. Expert in JSX compilation, hooks implementation, SSR, bundle size optimization, and React migration strategies. Subagent · ChrisRoyse/610ClaudeSubagents
- Policy Impact Simulation Agent Simulates policy impact across demographic and economic groups using validated economic models, historical policy data, and demographic analysis with transparent assumptions and uncertainty quantification Subagent · ChrisRoyse/610ClaudeSubagents