Subagent

PostgreSQL Database Administrator

Work with PostgreSQL databases using the PostgreSQL extension.

Type: Subagent
Repository: github/awesome-copilot
GitHub stars: 39.4k
License: MIT
Repo last updated: Sep 27, 2026
Source file: agents/postgresql-dba.agent.md

What PostgreSQL Database Administrator is

PostgreSQL Database Administrator is a subagent published in the github/awesome-copilot repository on GitHub, which has about 39.4k stars. The repository describes itself as: “Community-contributed instructions, agents, skills, and configurations to help you make the most of GitHub Copilot.”

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 Database Administrator and get back a compact result.

It is set up to use these tools: codebase, edit/editFiles, githubRepo, extensions, runCommands, database, pgsql_bulkLoadCsv, pgsql_connect, pgsql_describeCsv, pgsql_disconnect, pgsql_listDatabases, pgsql_listServers. Limiting tools is a good sign: the subagent can only do what those tools allow.

How to install PostgreSQL Database Administrator

Claude Code

Download postgresql-dba.agent.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 agents/postgresql-dba.agent.md, shared under the repository's MIT license. Read the full file on GitHub.

Before running any tools, use #extensions to ensure that ms-ossdata.vscode-pgsql is installed and enabled. This extension provides the necessary tools to interact with PostgreSQL databases. If it is not installed, ask the user to install it before continuing.

You are a PostgreSQL Database Administrator (DBA) with expertise in managing and maintaining PostgreSQL database systems. You can perform tasks such as:

Creating and managing databases
Writing and optimizing SQL queries
Performing database backups and restores
Monitoring database performance
Implementing security measures

You have access to various tools that allow you to interact with databases, execute queries, and manage database configurations. Always use the tools to inspect the database, do not look into the codebase.

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 Database Administrator?

PostgreSQL Database Administrator is a subagent for Claude Code and Claude Cowork from the github/awesome-copilot repository on GitHub. Work with PostgreSQL databases using the PostgreSQL extension.

How do I install PostgreSQL Database Administrator in Claude Code?

Download postgresql-dba.agent.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 Database Administrator 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 Database Administrator 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

Browse all skills, subagents, and plugins →

Listing data comes from the public GitHub repository and was last checked in September 2026. Excerpts are © their authors and shared under MIT. This directory is independent and not affiliated with Anthropic or the resource's authors.