custom-plugin-postgresql

内容来源：README.md（说明文档） · 原始地址 · 查看安装指南

原始内容

<div align="center">

<!-- Animated Typing Banner -->
<img src="https://readme-typing-svg.demolab.com?font=Fira+Code&weight=600&size=28&duration=3000&pause=1000&color=336791&center=true&vCenter=true&multiline=true&repeat=true&width=600&height=100&lines=PostgreSQL+Development+Assistant;8+Agents+%7C+12+Skills;Claude+Code+Plugin" alt="PostgreSQL Assistant" />

<br/>

<!-- Badge Row 1: Status Badges -->
[![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)](#)

<!-- Badge Row 2: Content Badges -->
[![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)](#)

<br/>

<!-- Quick CTA Row -->
[**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.

</div>

---

## Table of Contents

<details>
<summary>Click to expand</summary>

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

</details>

---

## Quick Start

### Prerequisites

- Claude Code CLI v2.0.27+
- Active Claude subscription

### Installation

<details open>
<summary><strong>Option 1: From Marketplace (Recommended)</strong></summary>

```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
```

</details>

<details>
<summary><strong>Option 2: Local Installation</strong></summary>

```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
```

</details>

### 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](https://github.com/pluginagentmarketplace/custom-plugin-postgresql/blob/HEAD/CONTRIBUTING.md) for contribution guidelines.

---

## License

Custom License - See [LICENSE](https://github.com/pluginagentmarketplace/custom-plugin-postgresql/tree/HEAD/LICENSE) for details.

Copyright (c) 2025 Dr. Umit Kacar & Muhsin Elcicek

---

<div align="center">
  <sub>Built with ULTRATHINK by Claude Code Plugin Team</sub>
</div>

Install Now · Explore Agents · Documentation · Star this repo

What is this?

PostgreSQL Development Assistant is a Claude Code plugin with 8 agents and 12 skills for comprehensive PostgreSQL database development and administration.

Click to expand

Quick Start
Features
Agents
Skills
Commands
Contributing
License

Quick Start

Prerequisites

Claude Code CLI v2.0.27+
Active Claude subscription

Installation

Option 1: From Marketplace (Recommended)

# 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

# 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 for contribution guidelines.

License

Custom License - See LICENSE for details.

_{Built with ULTRATHINK by Claude Code Plugin Team}