agentpluginsdirectory
HiAi-gg avatar

postgresql

v0.0.2

by HiAi-gg · author: HiAI

Safe, read-only PostgreSQL inspection, query diagnosis, performance analysis, and database health workflows for AI agents, with a bundled HiAI PostgreSQL MCP server.

What postgresql does, in the publisher's words

Safe, read-only PostgreSQL inspection, query diagnosis, performance analysis, and database health workflows for AI agents.

An Agent Plugin (spec 1.0.0), version 0.0.2.

  • Inspects PostgreSQL databases: identity, schemas, tables, columns, relationships, indexes, sizes.
  • Diagnoses slow queries with EXPLAIN (FORMAT JSON) (never executes the target statement).
  • Investigates performance: activity, long transactions, locks, table health, pg_stat_statements (when available).
  • Produces compact health reviews.
  • All through a bundled HiAI PostgreSQL MCP server: no third-party PostgreSQL MCP dependency.

Most coding agents already expose filesystem and general tools, but safe PostgreSQL inspection is a distinct capability. This plugin ships a read-only MCP that uses PostgreSQL's own server-side read-only enforcement, not a regex, as the primary safety boundary.

  • an AI database administrator,

From the project README, punctuation lightly normalized · Open the README on GitHub

Skills
5
MCP servers
1
Stars
1
License
MIT
Repo created
2026-08-08
Last pushed
2026-09-03
Publisher type
Organization
Version
0.0.2

Links

Skills · 5

diagnose-locks
Diagnose PostgreSQL lock contention: detect blocked sessions, find the blocking session, identify the lock, and explain the cause. Use when queries hang, transactions stall, or the database appears stuck.
diagnose-performance
Diagnose PostgreSQL performance issues: active sessions, long transactions, locks, table health, sizes, and pg_stat_statements. Use when the database is slow, under load, or when asked for a performance investigation.
diagnose-query
Diagnose why a PostgreSQL query is slow or suspicious: understand the SQL, inspect tables and indexes, EXPLAIN JSON, and propose measured next steps. Use when a query is slow, timing out, or has a suspicious plan.
inspect-database
Understand an unfamiliar PostgreSQL database: identity, schemas, important tables, relationships, indexes, and sizes. Use when onboarding to a database, mapping its structure, or before writing queries against it.
review-database-health
Produce a compact PostgreSQL health review: configuration signals, capacity, maintenance, locks/activity, large relations, and query statistics. Use when asked for an overall database health assessment or a pre-maintenance check.

Descriptions come from the frontmatter of each SKILL.md, punctuation lightly normalized.

MCP servers · 1

postgresqlstdio
bun run ${PLUGIN_ROOT}/packages/postgres-mcp/src/index.ts

Read from the plugin's own mcp.json. We list environment variable names, never values.

Category

Databases & Data. Assigned by this directory. Agent Plugins 1.0.0 has no category field, so no manifest declares one.

Keywords

postgresql · postgres · sql · database · mcp · agent-plugins

Related by publisher and keywords

  • supabaseHiAi-gg

    Investigate Supabase-backed apps: schema, data access, RLS, and auth via Supabase's official PostgREST MCP server.

  • cloudflareHiAi-gg

    Inspect and debug Cloudflare: Workers, DNS, request handling, and configuration, via Cloudflare's official Code Mode MCP server.

  • context7HiAi-gg

    Current library and framework documentation via Context7's first-party MCP server, with usage-discipline skills for when an agent should consult it.

  • figmaHiAi-gg

    Bring Figma design context into agent workflows: inspect design context, implement from design, map components, and compare code to design, via Figma's official MCP server.

  • firecrawlHiAi-gg

    Search, scrape, crawl, and extract from the web with Firecrawl's official MCP server, with focused workflow skills.

  • githubHiAi-gg

    Inspect and work with GitHub: pull requests, issues, CI, and repositories via GitHub's official MCP server, with focused workflow skills.

Add the verified badge to your README[![Verified by AgentPluginsDirectory.com against Schema 1.0.0](https://agentpluginsdirectory.com/badge.svg)](https://agentpluginsdirectory.com/plugins/postgresql)

✓ Verified . We fetched the manifest from GitHub and checked it against the official Agent Plugins 1.0.0 schema at agent-plugins.org.