PostgreSQL Database Administrator

Overview

PostgreSQL Database Administrator is built to work against a live database connection rather than inferring schema from the codebase. Its own instructions say to always use the database tools to inspect the database, not the code.

How it works

1. It checks that the ms-ossdata.vscode-pgsql extension is installed before doing anything, since that extension supplies the actual connection and query tools it relies on.
2. It connects to a server, lists available databases, and can visualize the schema directly from the live database rather than from migration files.
3. It handles day-to-day DBA tasks: creating and modifying databases, bulk-loading CSV data, writing and optimizing queries, and describing a CSV's structure before an import.
4. Because it works from the real database state, it can catch drift between what a migration file claims and what the schema actually looks like right now.
5. Security and performance monitoring sit alongside query work, so it's positioned as an ongoing DBA assistant rather than a one-off migration generator.

Examples

"Connect to the staging database and check whether the orders table has
an index on customer_id."

Installation

You need VS Code with the GitHub Copilot extension, plus the ms-ossdata.vscode-pgsql PostgreSQL extension, since the agent relies on it for the actual database connection and query tools.

1. Install the ms-ossdata.vscode-pgsql extension from the VS Code marketplace if you don't have it.
2. Create the agents folder and download the file into your repo:

   mkdir -p .github/agents
   curl -o .github/agents/postgresql-dba.agent.md \
     https://raw.githubusercontent.com/github/awesome-copilot/main/agents/postgresql-dba.agent.md
   

3. Reload VS Code, or open a new Copilot Chat; custom agents under .github/agents/ are picked up automatically.
4. Pick this agent from the mode picker in Copilot Chat and ask it to connect to a database to confirm it uses the extension's tools instead of guessing from code.