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

.kiro/steering/tech.md

postgres-mcp-pro-plus tech.md is an instructions file for Kiro from cloudthinker-ai/postgres-mcp-pro-plus. It costs 401 tokens per session, scanned A, original, MIT.

Development instructions for a Python PostgreSQL analysis server, including its dependencies, build commands, checks, and ways to start it.

In plain words
What is it for?
It helps contributors work with Python 3.12+, run automated tests, check code quality, build the package, and start the server locally or over a web connection.
Why use it?
It collects the commands and tool choices needed to install, test, format, type-check, build, and run the project.

Instructions file for Kiro

Written for Kiro: installed under .kiro/.

This is cloudthinker-ai/postgres-mcp-pro-plus's own configuration. It tells Kiro how to work on postgres-mcp-pro-plus itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything postgres-mcp-pro-plus configures →

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/tech.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.

agentmods badge for postgres-mcp-pro-plus tech.md

README.md
[![agentmods](https://agentmods.dev/badge/instructions/cloudthinker-ai/postgres-mcp-pro-plus/tech/github.svg)](https://agentmods.dev/instructions/cloudthinker-ai/postgres-mcp-pro-plus/tech)
Your own site
<a href="https://agentmods.dev/instructions/cloudthinker-ai/postgres-mcp-pro-plus/tech"><img src="https://agentmods.dev/badge/instructions/cloudthinker-ai/postgres-mcp-pro-plus/tech/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.

agentmods 80×15 button for postgres-mcp-pro-plus tech.md

Your own site · 80×15
<a href="https://agentmods.dev/instructions/cloudthinker-ai/postgres-mcp-pro-plus/tech"><img src="https://agentmods.dev/badge/instructions/cloudthinker-ai/postgres-mcp-pro-plus/tech.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 401 This file is loaded in full into every session.
When invoked 401 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.

ModelPer sessionOnce invoked
Fable 5.1 $0.00401 $0.00401
Opus 5.5 $0.00160 $0.00160
Sonnet 5.5 $0.00080 $0.00080
Haiku 4.5 $0.00040 $0.00040

Measured 17d ago against content hash ad47aaf5741a, 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 tech.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/tech.md · 70 lines

What it actually says

Tech Stack

Language & Runtime

  • Python 3.12+
  • Async/await patterns throughout (asyncio)

Build System

  • Package Manager: uv (Astral)
  • Build Backend: hatchling
  • Project Config: pyproject.toml

Key Dependencies

  • mcp[cli] - Model Context Protocol server framework (FastMCP)
  • psycopg[binary] + psycopg-pool - PostgreSQL async driver with connection pooling
  • pglast - PostgreSQL query parser
  • instructor - LLM integration for AI-powered analysis
  • pydantic - Data validation and settings
  • attrs - Data classes
  • humanize - Human-readable formatting

Development Tools

  • ruff - Linting and formatting (line-length: 150)
  • pyright - Type checking (standard mode)
  • pytest + pytest-asyncio - Testing
  • pre-commit - Git hooks for quality checks
  • docker - Container testing

Common Commands

# Install dependencies
uv sync --dev

# Run tests
uv run pytest

# Run linting
uv run pre-commit run --all-files

# Format code
uv run ruff format

# Type check
uv run pyright

# Build package
uv build

# Start server (stdio mode)
./start.sh

# Start server (SSE mode for web)
./start.sh --transport sse --sse-port 8099

# Start in restricted/read-only mode
./start.sh --access-mode restricted

Code Style

  • Line length: 150 characters
  • Quote style: double quotes
  • Import style: single-line imports, sorted
  • Naming: PEP8 conventions
  • Type hints: Required for function signatures
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.

  1. 17d ago First seen · 70 lines · 401 tokens per session scan A ad47aaf5741a

Subscribe to this mod's changes

postgres-mcp-pro-plus tech.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 401 tokens to every session, about $0.0016 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.

Related

postgres-mcp-pro-plus tech.md compared with instructions from other repositories

postgres-mcp-pro-plus tech.md next to 6 instructions from other repositories
ModTypeStarsLast pushLicenceScanTokensWorks with
postgres-mcp-pro-plus tech.mdcloudthinker-ai/postgres-mcp-pro-plusInstructions file718d agoMITA401Kiro
vscode buildNext.instructions.mdmicrosoft/vscodeInstructions file195ktodayMITA9,719GitHub Copilot
next.js AGENTS.mdvercel/next.jsInstructions file143ktodayMITA7,461Codex, OpenCode
vscode oss-third-party-notices.instructions.mdmicrosoft/vscodeInstructions file195ktodayMITA5,516GitHub Copilot
langchain AGENTS.mdlangchain-ai/langchainInstructions file149ktodayMITA4,680Codex, OpenCode
vscode copilot-instructions.mdmicrosoft/vscodeInstructions file195ktodayMITA3,093GitHub Copilot
deepseek-harness AGENTS.mddeepseek-ai/deepseek-harnessInstructions file274k2d agoMITA4,313Codex, OpenCode