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.
- 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
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/agents/postgresql-dba.agent.md
Supports: Workflow, inputs, outputs and stated boundaries
- Applicable licence ↗Checked
https://github.com/github/awesome-copilot/blob/f25421d3f1b8b3bb217f78a7c0567cf7ec117cd8/LICENSE
Supports: Redistribution and attribution
https://docs.github.com/en/copilot/reference/custom-agents-configuration
Supports: Host loading and effective permission boundaries