MCP server that teaches LLMs to write production grade Postgres SQL
For the past 10 years at Timescale (now Tiger Data), I've been been watching developers make mistakes in database design: forgetting to index foreign keys, creating case-sensitive email lookups, using arbitrary VARCHAR limits. And I've seen the pain and frustration when there is major downtime and botched migrations fixing things. AI coding could have made this better but is only making things worse. It's infuriating. So, I (along with my awesome team at Tiger Data) built an MCP server that auto-injects Postgres best practices into AI context to help. The biggest innovation: our…
MCP server that teaches LLMs to write production grade Postgres SQL launched on October 22, 2025 with 5 votes and more than 75% of that year's launches. The site was still online in September 2026, 1 year on.
What it does
Tiger CLI is the command-line interface for Tiger Cloud. It includes an MCP server for helping coding agents write production-level Postgres code. - timescale/tiger-cli
In the maker’s words, at launch
For the past 10 years at Timescale (now Tiger Data), I've been been watching developers make mistakes in database design: forgetting to index foreign keys, creating case-sensitive email lookups, using arbitrary VARCHAR limits. And I've seen the pain and frustration when there is major downtime and botched migrations…
Does a similar job
all alternatives →
Cloud-Ready Postgres MCP Server2025 · github.com · ▲167Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP/SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension…
InsForgeMar 2026 · insforge.dev · ▲622We built InsForge because we wanted to use pure prompts to build a production-grade app faster. In practice, AI isn’t reliable enough when generating code or configuring backend pieces like schema, RLS, auth, or functions. Postgres MCP and Supabase MCP are a good starting point, but they felt more like API wrappers for agents than something designed to guide AI safely through backend tasks. So we built our own MCP server on top of Postgres and added a set of context-engineering tools to make prompt-driven workflows more predictable. It gradually turned into a Postgres-based BaaS. Key…
Postgres extension for BM25 relevance-ranked full-text searchMar 2026 · github.com · ▲203Last summer we faced a conundrum at my company, Tiger Data, a Postgres cloud vendor whose main business is in timeseries data. We were trying to grow our business towards emerging AI-centric workloads and wanted to provide a state-of-the-art hybrid search stack in Postgres. We'd already built pgvectorscale in house with the goal of scaling semantic search beyond pgvector's main memory limitations. We just needed a scalable ranked keyword search solution too. The problem: core Postgres doesn't provide this; the leading Postgres BM25 extension, ParadeDB, is guarded behind AGPL; developing our…
- MAMy AI Native Resume2025 · ai.jakegaylor.com · ▲301
I've been deeply involved in working with AI agents and large language models (LLMs) for a while now. During a recent job search, I found myself repeatedly explaining my skills and experiences to various assistants. Around the same time, I was creating content for my website to help hiring teams understand my capabilities better and make informed decisions. MCP had started to gain momentum and I saw a way to reduce my toil. So I built an MCP server that can effectively communicate my qualifications as a job candidate. This server acts as an AI-powered resume, providing an understanding of my…
AI-Driven Index Tuning With Postgres MCP Server2025 · github.com · ▲11Hey HN, Postgres Pro is an open source Model Context Protocol (MCP) server built to support every stage of the development process. It does a lot more than help generate and run SQL—it helps you make sure your application and database actually run well. Features: - Industrial-strength tuning algorithms similar to those in MS SQL Server - “What if?” tool to evaluate LLM-generated index suggestions - Works with Cursor, etc., to make changes in ORM code - Ensures safe SQL execution with restricted mode - Includes health checks to stay ahead of production problems
HyperterseFeb 2026 · hyperterse.com · ▲86Hi HN, I’m Samrith, creator of Hyperterse. Today I’m launching Hyperterse 2.0, a schema-first framework for building MCP servers directly on top of your existing production databases. If you're building AI agents in production, you’ve probably run into agents needing access to structured, reliable data but wiring your business logic to MCP tools is tedious. Most teams end up writing fragile glue code. Or worse, giving agents unsafe, overbroad access. There isn’t a clean, principled way to expose just the right data surface to agents. Hyperterse lets you define a schema over your data and…
More ai this month
the category →
Paintings by AI models: programs run through a simulation of oil paint.
AI · 21d ago · stillwet.art
PixVerse R2▲381A real-time world model you can explore and change
AI · 30d ago · world.pixverse.video
Source: Show HN post ↗ · launch text quoted in part
Launched alongside, October 2025
the whole month →
I went down the rabbit hole on a side project and ended up building this: Strange Attractors(https://blog.shashanktomar.com/posts/strange-attractors). It’s built with three.js. Working on it reminded me of the little "maths for fun" exercises I used to do while learning programming in early days. Just trying things out, getting fascinated and geeky, and being surprised by the results. I spent way too much time on this, but it was extreme fun. My favorite part: someone pointed me to the Simone Attractor on Threads. It is a 2D attractor and I asked GPT to extrapolate it to…
AI · Oct 2025 · blog.shashanktomar.com
Autism Simulator▲779Hey all, I built this. It’s not trying to capture every autistic experience (that’d be impossible). It’s based on my own lived experience as well as that of friends on the spectrum. I'm trying to give people a feel for what masking, decision fatigue, and burnout can look like day-to-day. That’s hard to explain in words, but easier to show through choices and stats. I'm not trying to "define autism". I’ve gotten good feedback here about resilience, meds, and difficulty tuning. I’ll keep tweaking it. If even a few people walk away thinking, "ah, maybe that’s why my coworker struggles in those…
Life & fun · 2025 · autism-simulator.vercel.app
