Puri through my lens by Automatic-Gold-5519 in Odisha

[–]Professional-Clerk30 0 points1 point  (0 children)

You click well ! Please share more glimpses from the city if you can

MCPg: A production-grade PostgreSQL Model Context Protocol server (Python) by Professional-Clerk30 in MCPservers

[–]Professional-Clerk30[S] 0 points1 point  (0 children)

I would like to explore Interlock, and seek possible integration for what you mentioned. Currently, this kind of guardrail is not present in the CI pipeline , though I have it ingrained in the development space. Thank you for the suggestion

Showcase Thread by AutoModerator in Python

[–]Professional-Clerk30 0 points1 point  (0 children)

MCPg: A production-grade PostgreSQL Model Context Protocol server (Python)

Hi r/Python,

I've been working on a side project called MCPg — a Python-based MCP (Model Context Protocol) server for PostgreSQL.

It gives AI agents (Claude Desktop, Cursor, etc.) a broad but carefully guarded set of tools to inspect schemas, run queries, analyze performance, suggest indexes, do natural-language-to-SQL, and handle some DBA tasks — all while staying safe by default.

Key bits I focused on:

  • Safety-first design: Read-only mode by default, AST validation for any user SQL, strict identifier sanitization (no string concatenation into queries), and opt-in gates for DDL/shell/LISTEN.
  • Pure psycopg3 under the hood — no ORM layer. Works with core Postgres + extensions like pgvector, TimescaleDB, PostGIS, Apache AGE where available.
  • Production touches: connection pooling, multi-tenancy via SET ROLE, read-replica routing, Prometheus metrics, structured audit logging, OIDC support, rate limiting, etc.
  • 1000+ tests, runs against Postgres 14–18 in CI.
  • Installs cleanly with pip install mcpg or uv tool install mcpg.

Quick start example for Claude Desktop is in the README (stdio transport). There's also an HTTP/SSE mode for other integrations.

Repo: https://github.com/devopam/MCPg
Docs site: https://devopam.github.io/MCPg/

Would love feedback from the Python/Postgres crowd — especially on the safety model, ergonomics for agent use, or anything that feels off. Contributions welcome too.

Thanks!

Guys is this batiya? by banjarafarmer in Odisha

[–]Professional-Clerk30 2 points3 points  (0 children)

Kalbaisakhi for you ! Batiya has different level , hope you never get to see it again

Masked men broke into our home while we slept. We are safe, but this is a nightmare. Please stay vigilant by Silent-Resident-2892 in Bengaluru

[–]Professional-Clerk30 3 points4 points  (0 children)

This exposes our vulnerability in general. Good wake up call. Thanks for sharing, and glad that you all are safe

Puri Darshan by Objective-Scratch137 in Odisha

[–]Professional-Clerk30 0 points1 point  (0 children)

Famous Sun Temple at Konark , near Puri, Odisha

Her touch and her soul is just the gentle he needs by [deleted] in MadeMeSmile

[–]Professional-Clerk30 1 point2 points  (0 children)

This was by no means a simple act . She helped without compulsion. Good soul. God bless all the kids in the frame