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…
What it does
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 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 get_prompt_template tool lets the LLM auto-discover the right guidance without slash commands. Ask "design a schema for IoT devices" and it automatically pulls our Postgres schema design and hypertable guides. What's different from other MCP servers: Instead of thin API wrappers, I am teaching AI things like "Always index foreign key columns - Postgres won't do it for you" and "use TEXT not VARCHAR(255)". It includes versioned Postgres docs (15-17) with hybrid search, plus TimescaleDB-specific patterns. Try it with our free service: ``` curl -fsSL https://cli.tigerdata.com | sh tiger auth login tiger mcp install ``` Works with Claude Desktop, Cursor, Windsurf, VS Code. Open source. By the way: this approach might show how to implement Anthropic's new Agent Skills (previous discussion: https://news.ycombinator.com/item?id=45607117) entirely through MCP.
Does the same job
all alternatives →- 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…
- DLDatabase Labs – Postgres as a Service2014 · databaselabs.io · ▲46
More ai this month
the category →
I trained a 125M-parameter transformer to autocomplete piano performances in real time (~108 notes/sec on an iPhone 15). The idea is basically GitHub Copilot or Tabnine, except instead of prompting it with code, you prompt it by playing a few notes on a MIDI piano. The model then continues what you played, entirely on-device. The app is free if anyone wants to try it. Happy to answer questions about the model, training, Core ML, or the many things that didn't work.
AI · 17d ago · simedw.com
Astute▲585Automate your B2B brand going viral, with new media creators
AI · 18d ago · company-app.joinastute.com
Hey HN, Henry from Cactus here! We previously released Cactus Needle, a 14MB agentic LLM for tool call, device use, and structured extraction for phones, wearables, smart homes, small robots and microcontrollers. We got really great feedback here, and have now incorporated the suggestions to release Needle 2. The whole model is a single 14MB binary that runs a full session in 28MB of RAM; 45m parameters at 2bit compression. Needle hits 500 tokens/sec decode speed on a Raspberry Pi 5, sits between 400-1,500 tokens/sec on VR devices like Meta Quest 3S and Apple Vision Pro, and ranges…
AI · 26d ago · cactuscompute.com
Launched alongside, October 2025
the whole month →
- SA
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
- ASAutism Simulator▲779
Hey 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 · Oct 2025 · autism-simulator.vercel.app
