Use this skill whenever the user wants to write, edit, review, or structure pgEdge documentation. This includes: creating new documentation files, editing existing docs, setting up MkDocs project structure from the pgEdge template, writing README files, formatting markdown content, creating changelogs, structuring navigation, or reviewing docs for style compliance. Trigger whenever the user mentions writing docs, documentation, README, mkdocs, changelog, or asks to review/fix doc formatting. Also trigger when setting up a new project's documentation scaffolding. Do NOT trigger for code-only changes that happen to be in markdown (e.g., editing a CLAUDE.md or DESIGN.md with development guidelines).
Use this skill whenever the user wants to query, explore, or modify a PostgreSQL database using the psql command-line tool. This includes: running SQL queries against a Postgres database, exploring database schemas (listing tables, describing columns, checking indexes), inserting or updating data, running DDL statements, or any task where the user mentions psql, PostgreSQL, Postgres, or a database connection string starting with postgresql://. Trigger whenever the user mentions a database table, asks to 'check the database', 'run a query', 'look at the data', or references a Postgres connection — even casually. Do NOT trigger if the user is working with the pgedge-postgres MCP server (which has its own guardrails and knowledgebase), or if they're writing application code that uses a Postgres driver/ORM rather than the psql CLI directly.
Use when the user asks to scaffold, set up, create, or bootstrap a new full-stack pgEdge web application or web client. Trigger on phrases like 'new web app', 'scaffold a frontend', 'set up a React app', 'new pgEdge web project', 'create a new client', or when working in an empty/new directory and the user mentions React, MUI, or login pages in the context of starting from scratch. Do NOT trigger for edits to an existing app, for adding a single component, or for purely backend Go work.
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge. GitHub access is read-only (username + org membership).
Sign in to claimBased on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
A Claude Code plugin providing pgEdge-specific skills for documentation writing, and more to come.
Install the plugin with the following commands in Claude Code:
/plugin marketplace add pgEdge/pgedge-skills
/plugin install pgedge-skills@pgedge-skills
Documentation writing skill that:
The skill activates automatically when you work on documentation tasks. You can also invoke it explicitly:
/pgedge-skills:pgedge-docs
Scaffolding a new docs site:
Set up MkDocs documentation scaffolding for the pgEdge Vectorizer
project in ~/git/vectorizer. The docs should cover installation,
configuration, usage, and a function reference.
Reviewing existing docs:
Review the docs/ directory for style compliance. Check line length,
heading structure, list formatting, and product name usage, and fix
any issues you find.
Documenting a new feature:
Document the new cache_stats view for Spock. It exposes total
entries, expired entries, cache size in MB, and average access
count. Add it to the existing monitoring page and update the
changelog.
PostgreSQL psql skill that:
psql command-line tool.The skill activates automatically when working with PostgreSQL
databases via psql. You can also invoke it explicitly:
/pgedge-skills:pgedge-psql
Full-stack web app scaffolding skill that:
The skill activates automatically when starting a new full-stack project. Invoke explicitly with:
/pgedge-skills:pgedge-webapp
Scaffold a new pgEdge web app at ~/git/my-app called "My App".
For more information, visit docs.pgedge.com.
To report an issue, visit: github.com/pgEdge/pgedge-skills/issues.
This project is licensed under the PostgreSQL License.
npx claudepluginhub pgedge/pgedge-skills --plugin pgedge-skillsSupabase skills for Postgres best practices, JavaScript SDK (auth, database, storage, realtime), and CLI (migrations, edge functions, local dev).
Database architecture and SQL optimization with PostgreSQL expertise
Database plugin for database-documentation-gen
Postgres performance optimization and best practices from Supabase. 30 rules across 8 categories prioritized by impact.
SQL optimization, query tuning, and database performance expert for production systems
Commands for database schema design, migrations, and optimization