Nodb is a JSON REST API on top of your Postgres database. It uses native jsonb for Postgres to make the API easier to use, without the need to create schemas (besides its own). Since our previous launch was using MongoDB Atlas and wasn't really open-source, we decided to go open-source this time and use Postgres instead. Besides CRUD operations via API, Nodb uses pgvector extension to vectorise your proprietary data automatically using LLMs and embedding models of your choice and do retrieval-augmented generation from your own data as knowledge base. Currently supported LLMs are the ones from OpenAI and Anthropic and regarding embedding models the ones from OpenAI and Voyage AI. Last, but not least, Nodb offers real time subscriptions over CRUD operations. This makes it full fledged app development toolkit on top of Postgres. This project is divided into two Github repos (see links) one for SDK - as an NPM, and the other for actual backend API that the NPM package leverages (and you can deploy on your own). We prepared installation instructions for installing/dockerisation of Postgres with pgvector and deployment instructions for Fly.io. We plan to add a bunch more features, but would like to hear your feedback so far and if you have a feature on your mind please feel free to share here. Both repos on Github: * nearup-io/nodb * nearup-io/nodb-js

Nodb

Open Source Dev Kit for Postgres: API, RAG, & Real-Time CRUD

Open Source Dev Kit for Postgres: API, RAG, & Real-Time CRUD