PgStudio

What it does

PgStudio is a PostgreSQL IDE that lives natively inside VS Code. Security-audited, 250+ tests passing, and shipped with GitHub Copilot, OpenAI, Anthropic, Gemini, and local model (Ollama/LM Studio) support. No new window. No subscription. No context switching. It supports notebook editor, full-fledged DB operations, Live monitoring with DB dashboards, AI insights on performance, Secure AI assisted code reviews and SQL builder. Human-in-the-loop and learning focused query builder work-flow.

Explorer, SQL notebooks, live dashboard, visual designers and a schema-grounded AI assistant — one VS Code extension. MCP server, MIT core, PostgreSQL 12–17.

Run your full PostgreSQL workflow inside VS Code: connect to environments safely, inspect objects, execute SQL notebooks, explain plans, and ship faster with AI-guided optimization. NexQL is a VS Code PostgreSQL extension for SQL editing, query execution, query optimization, database exploration, schema design, ERD visualization, and AI-assisted PostgreSQL analysis. Built for practical SQL work: production-safe execution, notebook workflows, AI assistance, and schema-first exploration. -- Revenue by day, last 7 days SELECT date_trunc ( 'day' , created_at) AS day, COUNT (*) AS orders, SUM (amount) AS revenue FROM orders WHERE created_at >= NOW () - INTERVAL '7 days' GROUP BY day ORDER BY…from pgstudio.astrx.dev

• 
  Open Source PostgreSQL Studio2021 · supabase.com · ▲407

  Powerful PostgreSQL tool is now open source for self-hosting

• 
  pgStudioJun 2026 · apps.apple.com · ▲2

  The database IDE you deserve — Rust-powered, AI-enhanced

• 
  I open-sourced the in-memory PostgreSQL I built at work for E2E tests2024 · github.com · ▲379

  In-memory Postgres for unit/E2E tests. Contribute to hexclave/pgmock development by creating an account on GitHub.

• 
  Outerbase Studio – Open-Source Database GUI2024 · github.com · ▲356

  We just launched Outerbase Studio, the open-source version of our core database offering. It works in your browser or as a desktop app and supports MySQL, PostgreSQL, and SQLite. What it does: • Connects to MySQL, PostgreSQL, and SQLite databases. • Spin up local databases directly through the UI, even if you don’t have one running. • Manage and query your data in a lightweight, intuitive interface. • Completely open source. Why we built it: We wanted to share the core Outerbase experience with the developer community as a free, open-source tool. It’s simple, fast, and removes the barriers…

• 
  PSequel – a free PostgreSQL GUI Tool for Mac OS X2014 · psequel.com · ▲247

  Happy Cyber Monday!

• 
  Webstudio2022 · webstudio.is · ▲171

  An open source visual development platform

• 
  /dev/null▲482

  a social network for devs

  Dev tools · 3d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 28d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 26d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 23d ago · openbot.run

• 
  Talanoa▲346

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 20d ago · talanoa.email

• 
  CoreSpeed▲332

  One MCP for everything your agents need: apps, memory, tools

  Dev tools · 28d ago · corespeed.io

• 
  Brew ▲900

  Like Claude design for email marketing

  AI · May 2026 · brew.new

• 
  Kilo Code for VS Code▲896

  Parallel agents, diff reviewer, and multi-model comparisons

  Dev tools · May 2026 · kilo.ai

• 
  StoreClaw▲806

  Grow your store profits with agents that know how to sell

  AI · May 2026 · storeclaw.ai

• 
  PollyReach▲795

  Give your agent a real number and voice to make calls.

  AI · May 2026 · pollyreach.ai

• 
  Needle: We Distilled Gemini Tool Calling into a 26M Model▲776

  Hey HN, Henry here from Cactus. We open-sourced Needle, a 26M parameter function-calling (tool use) model. It runs at 6000 tok/s prefill and 1200 tok/s decode on consumer devices. We were always frustrated by the little effort made towards building agentic models that run on budget phones, so we conducted investigations that led to an observation: agentic experiences are built upon tool calling, and massive models are overkill for it. Tool calling is fundamentally retrieval-and-assembly (match query to tool name, extract argument values, emit JSON), not reasoning. Cross-attention…

  Life & fun · May 2026 · github.com

• 
  Files.md – Open-source alternative to Obsidian▲730

  🌱 Private, quiet space for thinking. Simple app for .md files. - zakirullin/files.md

  Dev tools · May 2026 · github.com