postgres-db

oimiragieo's avatarfrom oimiragieo

PostgreSQL database operations and management

⭐1stars🔀0forks📁View on GitHub🕐Updated Jan 11, 2026
[SQL and Databases]

When & Why to Use This Skill

This PostgreSQL Database Skill empowers Claude agents to perform end-to-end database management and operations directly within the chat interface. It supports a full suite of tools for executing SQL queries (CRUD), designing and modifying schemas, and performing critical administrative tasks like query plan analysis and maintenance. By automating routine database interactions, it significantly reduces context switching for developers and data architects while ensuring high performance through built-in optimization tools.

Use Cases

  • Schema Design and Evolution: Quickly create, describe, and manage database tables to iterate on application data structures.
  • Data Operations and Maintenance: Execute SELECT queries for data retrieval and perform authorized INSERT, UPDATE, or DELETE operations for data management.
  • Performance Tuning: Use the 'explain' tool to analyze query execution plans, identify bottlenecks, and optimize SQL performance.
  • Database Administration: Monitor active connections, inspect database locks, and run VACUUM operations to maintain database health and efficiency.
namepostgres-db
descriptionPostgreSQL database operations and management
version1.0.0
allowed-tools[Bash, Read]

PostgreSQL Database Skill

Overview

PostgreSQL database operations. 90%+ context savings.

Requirements

  • DATABASE_URL or PGHOST/PGUSER/PGPASSWORD
  • psql CLI installed

Tools (Progressive Disclosure)

Queries

Tool Description Confirmation
query Execute SELECT No
execute Execute INSERT/UPDATE/DELETE Yes
explain Query plan analysis No

Schema

Tool Description Confirmation
list-tables List tables No
describe Describe table No
create-table Create table Yes
drop-table Drop table REQUIRED

Admin

Tool Description
connections Active connections
locks View locks
vacuum Run VACUUM

BLOCKED

Tool Status
DROP DATABASE BLOCKED
TRUNCATE CASCADE BLOCKED

Agent Integration

  • database-architect (primary): Schema design
  • developer (primary): Data operations
  • performance-engineer (secondary): Query optimization