PostgreSQL Assistant

[![Version](https://img.shields.io/badge/Version-2.1.0-blue?style=for-the-badge)](https://github.com/pluginagentmarketplace/custom-plugin-postgresql/releases) [![License](https://img.shields.io/badge/License-Custom-yellow?style=for-the-badge)](LICENSE) [![Status](https://img.shields.io/badge/Status-Production-brightgreen?style=for-the-badge)](#) [![SASMP](https://img.shields.io/badge/SASMP-v1.3.0-blueviolet?style=for-the-badge)](#) [![Agents](https://img.shields.io/badge/Agents-8-orange?style=flat-square&logo=robot)](#-agents) [![Skills](https://img.shields.io/badge/Skills-12-purple?style=flat-square&logo=lightning)](#-skills) [![Commands](https://img.shields.io/badge/Commands-4-green?style=flat-square&logo=terminal)](#-commands) [![PostgreSQL](https://img.shields.io/badge/PostgreSQL-16+-336791?style=flat-square&logo=postgresql)](#)
[**Install Now**](#-quick-start) · [**Explore Agents**](#-agents) · [**Documentation**](#-skills) · [**Star this repo**](https://github.com/pluginagentmarketplace/custom-plugin-postgresql) --- ### What is this? > **PostgreSQL Development Assistant** is a Claude Code plugin with **8 agents** and **12 skills** for comprehensive PostgreSQL database development and administration.

--- ## Table of Contents

Click to expand

- [Quick Start](#-quick-start) - [Features](#-features) - [Agents](#-agents) - [Skills](#-skills) - [Commands](#-commands) - [Contributing](#-contributing) - [License](#-license)

--- ## Quick Start ### Prerequisites - Claude Code CLI v2.0.27+ - Active Claude subscription ### Installation

Option 1: From Marketplace (Recommended)

```bash # Step 1: Add the marketplace /plugin marketplace add pluginagentmarketplace/custom-plugin-postgresql # Step 2: Install the plugin /plugin install custom-plugin-postgresql@pluginagentmarketplace-postgresql # Step 3: Restart Claude Code # Close and reopen your terminal/IDE ```

Option 2: Local Installation

```bash # Clone the repository git clone https://github.com/pluginagentmarketplace/custom-plugin-postgresql.git cd custom-plugin-postgresql # Load locally /plugin load . # Restart Claude Code ```

### Verify Installation After restart, you should see these agents: ``` custom-plugin-postgresql:pg-fundamentals custom-plugin-postgresql:pg-sql-mastery custom-plugin-postgresql:pg-data-types custom-plugin-postgresql:pg-indexing custom-plugin-postgresql:pg-performance custom-plugin-postgresql:pg-administration custom-plugin-postgresql:pg-replication custom-plugin-postgresql:pg-advanced ``` --- ## Features - **8 Specialized Agents** covering all PostgreSQL topics - **12 Golden Format Skills** with assets, scripts, and references - **4 Commands** for common database operations - **SASMP v1.3.0 Compliant** agent-skill architecture - **Production-Grade** with error handling and observability --- ## Agents | Agent | Description | Primary Skill | |-------|-------------|---------------| | `pg-fundamentals` | Master PostgreSQL basics | pg-basics | | `pg-sql-mastery` | SQL excellence and query writing | pg-queries | | `pg-data-types` | Type system mastery | pg-ddl | | `pg-indexing` | Index strategies and optimization | pg-indexes | | `pg-performance` | Performance tuning and analysis | pg-performance | | `pg-administration` | DBA operations and maintenance | pg-backup | | `pg-replication` | High availability setup | pg-replication | | `pg-advanced` | PL/pgSQL and extensions | pg-functions | --- ## Skills ### Core Skills | Skill | Description | |-------|-------------| | `pg-basics` | PostgreSQL fundamentals and setup | | `pg-ddl` | Data Definition Language | | `pg-dml` | Data Manipulation Language | | `pg-queries` | Advanced query techniques | ### Performance Skills | Skill | Description | |-------|-------------| | `pg-indexes` | Index types and strategies | | `pg-performance` | Query optimization | | `pg-transactions` | Transaction management | ### Administration Skills | Skill | Description | |-------|-------------| | `pg-backup` | Backup and recovery | | `pg-replication` | Replication setup | | `pg-security` | Security hardening | ### Advanced Skills | Skill | Description | |-------|-------------| | `pg-functions` | PL/pgSQL programming | | `pg-extensions` | Extension management | --- ## Commands | Command | Description | |---------|-------------| | `/pg-check` | Database health checks | | `/pg-query` | Execute query with EXPLAIN ANALYZE | | `/pg-optimize` | Performance optimization suggestions | | `/pg-backup` | Create database backups | --- ## Contributing See [CONTRIBUTING.md](CONTRIBUTING.md) for contribution guidelines. --- ## License Custom License - See [LICENSE](LICENSE) for details. Copyright (c) 2025 Dr. Umit Kacar & Muhsin Elcicek ---

_{Built with ULTRATHINK by Claude Code Plugin Team}