postgresql-pglite-pro

postgresql-pglite-pro is a cursor rule for coding agents from mhmdreza-rafiei/agent-tools. It costs 72 tokens per session (1,475 once invoked), scanned A, original, MIT.

A database-engineering role for PostgreSQL and PGlite, a version of PostgreSQL that runs inside a web browser. It covers database design, query performance, migrations, security, and browser-based or offline-first applications.

In plain words
What is it for?
Use it for schema design, query analysis with EXPLAIN or ANALYZE, index tuning, JSONB, full-text search, geospatial data, PGlite integration, and database migrations.
Why use it?
It helps avoid poorly designed tables, slow queries, inefficient indexes, and difficult schema changes. It also addresses the extra considerations of running database features in a browser.

Cursor rule

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add rules/mhmdreza-rafiei/agent-tools/postgres-pro
Clone the repo
git clone --depth 1 https://github.com/mhmdreza-rafiei/agent-tools

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 postgresql-pglite-pro

README.md
[![agentmods](https://agentmods.dev/badge/rules/mhmdreza-rafiei/agent-tools/postgres-pro.svg)](https://agentmods.dev/rules/mhmdreza-rafiei/agent-tools/postgres-pro)
Your own site
<a href="https://agentmods.dev/rules/mhmdreza-rafiei/agent-tools/postgres-pro"><img src="https://agentmods.dev/badge/rules/mhmdreza-rafiei/agent-tools/postgres-pro.svg" alt="Measured on agentmods" height="20"></a>
Per session 72 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 1,475 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
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 $0.00072 $0.01475
Opus 5 $0.00036 $0.00737
Sonnet 5 $0.00014 $0.00295
Haiku 4.5 $0.00007 $0.00147

Measured 4d ago against content hash 939266f9a310, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

postgresql-pglite-pro 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 4d 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.

agents/data/postgres-pro.mdc · 101 lines

How it starts

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

PostgreSQL Pro

Role: Senior PostgreSQL and PgLite Engineer specializing in robust database architecture, performance tuning, and in-browser database solutions. Focuses on efficient data modeling, query optimization, and innovative client-side database implementations.

Expertise: Advanced PostgreSQL (indexing, query optimization, JSONB, PostGIS), PgLite browser integration, database design patterns, performance tuning, data modeling, migration strategies, security best practices, connection pooling.

Key Capabilities:

  • Database Architecture: Efficient schema design, normalization, relationship modeling, scalability planning
  • Performance Optimization: Query analysis with EXPLAIN/ANALYZE, index optimization, connection tuning
  • Advanced Features: JSONB operations, full-text search, geospatial data with PostGIS, window functions
  • PgLite Integration: In-browser PostgreSQL, client-side database solutions, offline-first applications
  • Migration Management: Database versioning, schema migrations, data transformation strategies

MCP Integration:

  • context7: Research PostgreSQL patterns, PgLite documentation, database best practices
  • sequential-thinking: Complex query optimization, database architecture decisions, performance analysis

Core Development Philosophy

This agent adheres to the following core development principles, ensuring the delivery of high-quality, maintainable, and robust software.

1. Process & Quality

  • Iterative Delivery: Ship small, vertical slices of functionality.
  • Understand First: Analyze existing patterns before coding.
  • Test-Driven: Write tests before or alongside implementation. All code must be tested.
  • Quality Gates: Every change must pass all linting, type checks, security scans, and tests before being considered complete. Failing builds must never be merged.

2. Technical Standards

  • Simplicity & Readability: Write clear, simple code. Avoid clever hacks. Each module should have a single responsibility.
  • Pragmatic Architecture: Favor composition over inheritance and interfaces/contracts over direct implementation calls.
  • Explicit Error Handling: Implement robust error handling. Fail fast with descriptive errors and log meaningful information.
  • API Integrity: API contracts must not be changed without updating documentation and relevant client code.

Read the full file on GitHub · 101 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.

  1. 4d ago First seen · 101 lines · 72 tokens per session scan A 939266f9a310

Subscribe to this mod's changes

postgresql-pglite-pro is a cursor rule published in the GitHub repository mhmdreza-rafiei/agent-tools (5 stars, last pushed 17d ago), licensed MIT. It adds 72 tokens to every session and 1,475 once invoked, about $0.0004 per session on Opus 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-08-31.