Skip to main content
affpapa.org
RU EN
subagent GitHub Copilot official · GitHub

PostgreSQL Database Administrator — GitHub Copilot subagent

Subagent for managing PostgreSQL databases with the VS Code extension. It executes queries, inspects schemas, and handles admin tasks directly in Copilot.

Install into GitHub Copilot · Manually: put the files in place All methods and platforms ↓ 
.github/agents/postgresql-dba.agent.md
Open on GitHub

What PostgreSQL Database Administrator does

This subagent handles PostgreSQL administrative tasks directly in the editor. It runs SQL queries, visualizes schemas, and loads CSV files using actions like pgsql_query or pgsql_bulkLoadCsv. The prompt instructs the agent to inspect the live database with tools instead of scanning repository files.

It requires the ms-ossdata.vscode-pgsql extension. Without this extension, the agent stops and asks you to install it.

Install this if you manage Postgres instances inside VS Code. Without the extension, it is useless.

What it helps with

  • connect to PostgreSQL servers and inspect databases
  • execute and optimize SQL queries
  • bulk load CSV data into database tables
  • visualize database schema structures

Example prompts for the agent

  • Connect to the PostgreSQL server and list all databases.
  • Optimize this SQL query and visualize the table schema.
  • Bulk load data from data.csv into the orders table.

How to install PostgreSQL Database Administrator

Manually: put the files in place

.github/agents/postgresql-dba.agent.md

From the same set554

The whole set →
git-commit official github This skill reviews Git changes, stages related files, and creates Conventional Commits. Use it when you want an agent to make one commit or split work into separate commits. GitHub Copilot 47,165installs excalidraw-diagram-generator official github Turn a plain-language description into an Excalidraw diagram. Useful for mapping processes, system structure, and relationships between entities. GitHub Copilot 31,639installs multi-stage-dockerfile official github This skill guides GitHub Copilot in writing multi-stage Dockerfiles for different languages and frameworks. Use it when the final runtime image should contain fewer build dependencies. GitHub Copilot 29,688installs documentation-writer official github Skill that turns the agent into a technical writer following the Diátaxis framework: tutorials, how-to guides, reference, and explanation. Proposes structure before writing. GitHub Copilot 27,757installs prd official github Turns a feature idea into a structured PRD with user stories, technical requirements, and risks. Use it when planning a software feature or an AI-powered one. GitHub Copilot 24,035installs refactor official github This skill reshapes existing code without changing its external behavior. Use it for gradual cleanup of large functions, duplication, weak types, and code smells. GitHub Copilot 22,321installs java-springboot official github Gives GitHub Copilot Spring Boot development practices, from project layout to tests and security. Use it when writing or reviewing Java application code. GitHub Copilot 21,272installs create-readme official github This skill reviews a project and creates a structured README.md. Use it when the repository needs clear documentation based on its actual files and code. GitHub Copilot 19,081installs

Similar

microservices-architect VoltAgent Community Designs distributed architectures and breaks monoliths into independent microservices. Sets up communication patterns across services using gRPC, Kafka, and service meshes. Claude Code 376installs django-developer VoltAgent Community Subagent for Django 4+ and Python 3.11+ web development in Claude Code. Handles ORM query optimization, Django REST Framework APIs, and async views. Claude Code 344installs iot-engineer VoltAgent Community This subagent helps plan IoT systems from device connectivity and edge processing to cloud services. Use it when a project has varied connectivity needs or substantial data flows. Claude Code 238installs ai-engineer Seth Hobson This subagent designs LLM applications, RAG systems, and AI agents. Use it when a project needs vector search, model orchestration, or multimodal AI. Claude Code CX Codex Cursor 7,687installs business-analyst Seth Hobson This subagent analyzes business data and helps shape KPIs, forecasts, and financial models. Use it to turn a business question into an analysis plan and recommendations. Claude Code CX Codex Cursor 3,855installs sql-pro VoltAgent Community Subagent for optimizing complex SQL queries, designing database schemas, and fixing performance bottlenecks across PostgreSQL, MySQL, SQL Server, and Oracle. Claude Code 3,602installs sql-pro Seth Hobson Helps design database schemas, inspect query plans, and tune SQL for OLTP and OLAP systems. Use it for database optimization or complex analysis. Claude Code CX Codex Cursor 3,602installs data-scientist VoltAgent Community Subagent for exploratory data analysis, hypothesis testing, and building machine learning models directly in Claude Code. Claude Code 3,342installs

Questions about PostgreSQL Database Administrator

How to install PostgreSQL Database Administrator?

Save the prompt file to .cursor/agents/postgresql-dba.md, .claude/agents/postgresql-dba.md, or .codex/agents/postgresql-dba.md.

What does PostgreSQL Database Administrator do?

It manages PostgreSQL databases by running queries with pgsql_query, loading CSV files, inspecting connections, and visualizing schemas.

What dependencies are required?

You must install and enable the ms-ossdata.vscode-pgsql extension. The subagent relies on its tools to access PostgreSQL.

Source text

postgresql-dba.agent.md · MIT 
---
description: "Work with PostgreSQL databases using the PostgreSQL extension."
name: "PostgreSQL Database Administrator"
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"]
---

# PostgreSQL Database Administrator

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.

© github · MIT · github/awesome-copilot

See also

Project sponsors

Companies that keep this analytics open
Gold sponsor
Nutra.Club

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor