---
title: "PostgreSQL extension operator: review, role & definition · Undominated.ai"
canonical: https://undominated.ai/agents/github-postgresql-dba/
description: "A small Copilot profile that routes database work through the PostgreSQL extension’s tools."
---

# PostgreSQL extension operator: review, role & definition · Undominated.ai

> A small Copilot profile that routes database work through the PostgreSQL extension’s tools.

[← Explore all agents](/agents/)

DATABASE ADMINISTRATION / GitHub community

# PostgreSQL extension operator

A small Copilot profile that routes database work through the PostgreSQL extension’s tools.

 [Use this definition ↓](#setup)[Original source ↗](https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/agents/postgresql-dba.agent.md)

SOURCE REVIEW

 Reviewed 2026-10-14
 Evidence 3 linked sources
 Publisher GitHub community
 Licence [MIT ↗](https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/LICENSE)
 Revision f25421d3f1b8
 [Read what was—and wasn’t—checked ↓](#review)

“Work with PostgreSQL databases using the PostgreSQL extension.”

 [GitHub community · upstream description ↗](https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/agents/postgresql-dba.agent.md) Our analysis follows below.

01 / THE REASONING

## Why this made the selection.

 - The first gate checks that ms-ossdata.vscode-pgsql is installed and enabled before using its tools.
- The tool list explicitly includes connection, CSV inspection/import, query and database-modification operations.

### A good fit for

 - Supply an authorized PostgreSQL connection and a concrete administration or inspection task.
- Use extension-backed live inspection and SQL rather than guessing database state from application code.

### Weigh up before choosing

 - This is a thin routing profile without backup verification, destructive-action gates or an enforced read-only mode; claimed DBA tasks are not validated implementations.
- Source-only component: inspect its upstream context and dependencies before adapting it; no standalone runnable bundle is offered.

02 / THE REVIEW RECORD

## What we actually inspected.

Source review has boundaries. A clear record is more useful than a “safe” badge.

### Material inspected

 - agents/postgresql-dba.agent.md (pinned complete source retained)
- LICENSE
- Repository README and current official host configuration documentation

### Our findings

 - The first gate checks that ms-ossdata.vscode-pgsql is installed and enabled before using its tools.
- The tool list explicitly includes connection, CSV inspection/import, query and database-modification operations.

### Not established by this review

 - Source review only: no agent was installed or invoked. Task correctness, effective host restrictions and integration behaviour were not tested.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

## Use the role in your project.

[Upstream setup instructions ↗](https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/agents/postgresql-dba.agent.md)
 - Read the pinned source and its licence, then configure an explicitly bounded host context.
- Enable the PostgreSQL extension, verify current tool aliases and connect with a task-specific role; review write operations before execution.
- Supply an authorized PostgreSQL connection and a concrete administration or inspection task.

### Before you start

 - VS Code PostgreSQL extension
- Authorized connection with scoped database role

### Compatibility

GitHub Copilot

### Implementation

Markdown

### Host-mediated agent profile

 - Declared tools: codebase, edit/editFiles, githubRepo, extensions, runCommands, database, pgsql_bulkLoadCsv, pgsql_connect, pgsql_describeCsv, pgsql_disconnect, pgsql_listDatabases, pgsql_listServers, pgsql_modifyDatabase, pgsql_open_script, pgsql_query, pgsql_visualizeSchema. Effective host permissions still govern access; shell or execution tools can write files and contact networks.

### Cost model

The definition has the stated open-source licence. Model/host usage and any connected service or execution environment can incur separate costs.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Pinned upstream agent definition ↗](https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/agents/postgresql-dba.agent.md) Checked 2026-10-14 https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/agents/postgresql-dba.agent.md Supports: Workflow, inputs, outputs and stated boundaries
- [Applicable licence ↗](https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/LICENSE) Checked 2026-10-14 https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/LICENSE Supports: Redistribution and attribution
- [Host configuration and tool inheritance ↗](https://docs.github.com/en/copilot/reference/custom-agents-configuration) Checked 2026-10-14 https://docs.github.com/en/copilot/reference/custom-agents-configuration Supports: Host loading and effective permission boundaries

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### CodeTour Guide Builder ↗ Plans and writes guided code walkthroughs with file references and a maintenance checklist.](/agents/github-code-tour/)[### Database Reviewer ↗ Reviews PostgreSQL queries, schemas and migrations for performance, integrity and Row Level Security, reporting findings only.](/agents/ecc-database-reviewer/)[### Oracle-to-PostgreSQL migration expert ↗ Phases an Oracle-to-PostgreSQL migration and keeps the source as the behaviour to match.](/agents/github-oracle-to-postgres-migration-expert/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Find reusable instructions](/skills/)
- [Inspect connections](/mcp-servers/)
- [Build a toolkit](/tools/)
- [Choose the model](/compare/)
