← Explore all agents

DATABASE ADMINISTRATION / GitHub community

PostgreSQL extension operator

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

“Work with PostgreSQL databases using the PostgreSQL extension.”

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.

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 ↗
  1. Read the pinned source and its licence, then configure an explicitly bounded host context.
  2. Enable the PostgreSQL extension, verify current tool aliases and connect with a task-specific role; review write operations before execution.
  3. 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

04 / FOLLOW THE EVIDENCE

The source trail.

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

  1. https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/agents/postgresql-dba.agent.md

    Supports: Workflow, inputs, outputs and stated boundaries

  2. Applicable licence ↗Checked

    https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/LICENSE

    Supports: Redistribution and attribution

  3. https://docs.github.com/en/copilot/reference/custom-agents-configuration

    Supports: Host loading and effective permission boundaries

Evidence & Ask