Postgresql Dba — Agent Skill by GitHub

From the author

Work with PostgreSQL databases using the PostgreSQL extension.

— the description by aaronpowell

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

The PostgreSQL Database Administrator skill equips an AI agent with the expertise and tools required to manage PostgreSQL database environments. By leveraging the PostgreSQL extension, the agent can perform administrative tasks, execute complex SQL queries, and maintain database health. The agent is designed to interact directly with database instances to inspect schemas, manage configurations, and perform data operations, ensuring that database management is handled through verified database tools rather than manual code inspection.

What it does

Connects to and manages PostgreSQL database servers and instances
Executes and optimizes SQL queries for data retrieval and manipulation
Visualizes database schemas to understand structure and relationships
Performs bulk data loading from CSV files
Manages database configurations and administrative tasks
Verifies the presence of the required PostgreSQL extension before operation

When to use it

When you need to perform administrative tasks on a PostgreSQL database
When you need to run complex queries or analyze database performance
When you need to visualize the schema of an existing database
When you need to import data from CSV files into PostgreSQL tables

Advantages

Provides direct, tool-based interaction with database systems
Ensures database operations are performed using specialized database tools
Automates routine administrative and data management tasks
Reduces manual effort in schema analysis and query execution

Usage examples

“List all databases on the current server and visualize the schema for the 'users' database.”: The agent connects to the server, lists the available databases, and generates a visual representation of the 'users' database schema.
“Load the data from customer_data.csv into the 'customers' table.”: The agent uses the bulk load tool to import the specified CSV file into the target PostgreSQL table.

Install

Download the custom agent as a ZIP:
https://autogineer.com/agent-skills/github/postgresql-dba/download

Extract the agent file into .github/agents, then commit it:

mkdir -p .github/agents && unzip -j postgresql-dba.zip 'postgresql-dba/postgresql-dba.agent.md' -d .github/agents

Keep the LICENSE and ATTRIBUTION.md files from the ZIP with your copy.

Documentation by aaronpowell

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.

Files

ATTRIBUTION.mdAdded by AutoGineer876 B
LICENSELicence file added by AutoGineer1.0 KiB
postgresql-dba.agent.md1.2 KiB

postgresql-dba.agent.md

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.

Requirements and compatibility

Written for: GitHub Copilot

Works with: GitHub Copilot

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Anndata
K-Dense· Community
A Python framework for managing annotated data matrices in single-cell genomics and general research workflows.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k
Liteparse
K-Dense· Community
Local document and PDF parsing with spatial text extraction and bounding box support.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
Apache-2.0Low riskHas scriptsGitHub stars of the source repository56.4k
Usfiscaldata
K-Dense· Community
Access U.S. Treasury federal financial data via the Fiscal Data REST API.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k
Geopandas
K-Dense· Community
Guidance and local audit tools for Python workflows using GeoPandas 1.2.0 for spatial data analysis.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskHas scriptsGitHub stars of the source repository56.4k
Markitdown
K-Dense· Community
A lightweight utility for converting diverse document formats into structured Markdown for analysis, search, and LLM ingestion.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskHas scriptsGitHub stars of the source repository56.4k
Zarr Python
K-Dense· Community
A guide for storing and querying chunked N-D scientific arrays using Zarr-Python 3.
Data and AIClaude CodeClaude appsOpenAI Codex+14 more
MITLow riskGitHub stars of the source repository56.4k