Centia.io – Open PostgreSQL/PostGIS back end for developers

In plain words

Centia.io is a backend-as-a-service platform built on PostgreSQL and PostGIS for developers. It automatically generates APIs from database schemas and provides real-time updates without requiring manual setup. The service can be self-hosted using a Docker image, giving developers flexibility in deployment options. It targets developers who want to quickly build spatial or relational database applications without managing infrastructure.

written from the facts on this page · September 2026

From the sources

Centia.io is a Backend as a Service (BaaS) that provides data, auth, realtime, file storage, and developer tooling so you can focus on shipping your app. Start with the data model you define, connect with an SDK, and add realtime where you need it.

Build fast on managed Centia Cloud or self-host with Docker. Get PostgreSQL with PostGIS, OAuth2, realtime APIs, SDKs, and native MCP support for AI agents.

• 
  Hasura – Fast, instant GraphQL APIs on Postgres2018 · github.com · ▲382

  Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events. - hasura/graphql-engine

• QG
  Quickly generate REST API (for Postgres db)2019 · ▲70
• 
  Postgres as a VectorDB GUI2024 · github.com · ▲162

  Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.

• 
  SnapQL – Desktop app to query Postgres with AI2025 · github.com · ▲104

  SnapQL is an open-source desktop app (built with Electron) that lets you query your Postgres database using natural language. It’s schema-aware, so you don’t need to copy-paste your schema or write complex SQL by hand. Everything runs locally — your OpenAI API key, your data, and your queries — so it's secure and private. Just connect your DB, describe what you want, and SnapQL writes and runs the SQL for you.

• 
  GraphQL Centaur – GraphQL Generation tool for MongoDB Stucco2020 · github.com · ▲28

  😱 GraphQL Editor Official CLI - Generate and maintain GraphQL Backend and GraphQL Server - graphql-editor/graphql-editor-cli

• 
  GraphQL Centaur2020 · github.com · ▲72

  Generate GraphQL resolvers easily with GraphQL Centaur CLI

• 
  /dev/null▲483

  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 · 27d 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 · 25d ago · github.com

• 
  OpenBot▲362

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

  Dev tools · 23d ago · openbot.run

• 
  Talanoa▲345

  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

• 
  Cursor 2.0▲957

  Our first coding model and new interface for agents

  AI · Oct 2025 · cursor.com

• 
  Flask▲806

  Notion + Loom, for video collaboration.

  AI · 2025 · flask.do

• 
  Strange Attractors▲804

  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

• 
  Orchestra▲793

  A chat-centric workspace for builders and modern teams

  Work · 2025 · orch.so

• 
  Autism 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 · 2025 · autism-simulator.vercel.app

• 
  Director▲768

  Lovable for web automation

  AI · 2025 · director.ai