What is postgres-mcp-pro-plus structure.md?

Project-structure instructions for a PostgreSQL analysis server, showing where its server, database connection, health-check, and query-plan code belongs.

It helps developers locate the package entry point, SQL safety and connection code, database health checks, and query-plan analysis files.

It gives contributors a map of the codebase so they can find the relevant component before making changes.

How cloudthinker-ai/postgres-mcp-pro-plus configures Kiro

Reuse

Borrowing it

Nothing to install: this file belongs to cloudthinker-ai/postgres-mcp-pro-plus. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file

curl -O https://raw.githubusercontent.com/cloudthinker-ai/postgres-mcp-pro-plus/cloudthinker/postgres-mcp-pro-plus/.kiro/steering/structure.md

Clone the repo

git clone --depth 1 https://github.com/cloudthinker-ai/postgres-mcp-pro-plus

Made for: Kiro.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/instructions/cloudthinker-ai/postgres-mcp-pro-plus/structure/github.svg)](https://agentmods.dev/instructions/cloudthinker-ai/postgres-mcp-pro-plus/structure)

Your own site

<a href="https://agentmods.dev/instructions/cloudthinker-ai/postgres-mcp-pro-plus/structure"><img src="https://agentmods.dev/badge/instructions/cloudthinker-ai/postgres-mcp-pro-plus/structure/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/instructions/cloudthinker-ai/postgres-mcp-pro-plus/structure"><img src="https://agentmods.dev/badge/instructions/cloudthinker-ai/postgres-mcp-pro-plus/structure.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 796 This file is loaded in full into every session.

When invoked 796 The same file — it is already loaded in full.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00796	$0.00796
Opus 5.5	$0.00318	$0.00318
Sonnet 5.5	$0.00159	$0.00159
Haiku 4.5	$0.00080	$0.00080

Measured 17d ago against content hash db71a3540f06, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

postgres-mcp-pro-plus structure.md scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 17d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.kiro/steering/structure.md · 71 lines

How it starts

The opening of the file, as written. The whole thing — 71 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Project Structure

postgres-mcp-pro-plus/
├── src/postgres_mcp_pro_plus/     # Main package
│   ├── __init__.py                # Entry point, main() function
│   ├── server.py                  # MCP server, tool registration, CLI
│   ├── artifacts.py               # Response data structures
│   │
│   ├── sql/                       # Database connectivity layer
│   │   ├── sql_driver.py          # Connection pool, query execution
│   │   ├── safe_sql.py            # SafeSqlDriver with restrictions
│   │   ├── bind_params.py         # Parameter binding utilities
│   │   ├── extension_utils.py     # PostgreSQL extension helpers
│   │   └── index.py               # SQL module exports
│   │
│   ├── database_health/           # Health monitoring components
│   │   ├── database_health.py     # Main health tool orchestrator
│   │   ├── index_health_calc.py   # Index health checks
│   │   ├── connection_health_calc.py
│   │   ├── vacuum_health_calc.py
│   │   ├── sequence_health_calc.py
│   │   ├── replication_calc.py
│   │   ├── buffer_health_calc.py
│   │   └── constraint_health_calc.py
│   │
│   ├── explain/                   # Query plan analysis
│   │   └── explain_plan.py        # EXPLAIN tool with HypoPG support
│   │
│   ├── index/                     # Index optimization
│   │   ├── dta_calc.py            # Database Tuning Advisor algorithm
│   │   ├── llm_opt.py             # LLM-powered optimization
│   │   ├── index_opt_base.py      # Base classes
│   │   └── presentation.py        # Text output formatting
│   │
│   ├── top_queries/               # Query performance analysis
│   │   └── top_queries_calc.py    # pg_stat_statements analysis
│   │
│   ├── blocking_queries.py        # Lock contention analysis
│   ├── database_overview.py       # Comprehensive DB assessment
│   ├── schema_mapping.py          # Schema relationship analysis
│   └── vacuum_analysis.py         # Vacuum/bloat analysis
│
├── tests/
│   ├── conftest.py                # Pytest fixtures, Docker containers
│   ├── utils.py                   # Test utilities
│   ├── unit/                      # Unit tests (mocked)
│   └── integration/               # Integration tests (real DB)
│
├── scripts/security/              # Security scanning scripts
├── plan/                          # Analysis documentation
└── .kiro/
    ├── specs/                     # Feature specifications
    ├── steering/                  # AI guidance rules
    └── hooks/                     # Agent automation hooks

Read the full file on GitHub · 71 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

17d ago First seen · 71 lines · 796 tokens per session scan A db71a3540f06

Subscribe to this mod's changes

postgres-mcp-pro-plus structure.md is an instructions file published in the GitHub repository cloudthinker-ai/postgres-mcp-pro-plus (7 stars, last pushed 18d ago), licensed MIT. It adds 796 tokens to every session, about $0.0032 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-10-20.

Databases PostgreSQL

postgres-mcp-pro-plus structure.md next to 6 instructions from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
postgres-mcp-pro-plus structure.mdcloudthinker-ai/postgres-mcp-pro-plus	Instructions file	7	18d ago	MIT	A	796	Kiro
vscode buildNext.instructions.mdmicrosoft/vscode	Instructions file	195k	today	MIT	A	9,719	GitHub Copilot
next.js AGENTS.mdvercel/next.js	Instructions file	143k	today	MIT	A	7,461	Codex, OpenCode
vscode oss-third-party-notices.instructions.mdmicrosoft/vscode	Instructions file	195k	today	MIT	A	5,516	GitHub Copilot
langchain AGENTS.mdlangchain-ai/langchain	Instructions file	149k	today	MIT	A	4,680	Codex, OpenCode
vscode copilot-instructions.mdmicrosoft/vscode	Instructions file	195k	today	MIT	A	3,093	GitHub Copilot
deepseek-harness AGENTS.mddeepseek-ai/deepseek-harness	Instructions file	274k	2d ago	MIT	A	4,313	Codex, OpenCode

postgres-mcp-pro-plus: Instructions file for Kiro