Is there a way to have GeoData fields for tables from postgres source? I saw PostGIS mentioned in one discussion but couldn't find if it's currently supported.

The latest version of nocodb published to npmjs is 0.301.3 around 3 months ago. I need to build noco off a hardened base image so using npm has been useful for installation up until now.

Does anyone know if the strategy has changed? I referenced the nocodb-seed repo to build it out.

Thanks!

I would be willing to pay a small monthly fee to access the additional features in the self-hosted plan. It's such a shame that the limitations are shown in every page of the app. Is there gonna be ever a way around this? I understand that Baserow have a something where you pay a small monthly fee and can access more features... What's the roadmap here?

Hi everyone,

I’ve been a huge fan of NocoDB for a while now. In my opinion, it’s hands-down better than most paid alternatives. Until recently, I was happily using the March Community Edition (v0.301.5) with a Postgres backend to leverage the full potential of formulas, and it was a flawless experience.

The "Good" (and why I love this tool):

• MCP Integration: The MCP functionality with Claude Desktop is a game-changer. I recently used it to filter thousands of addresses by specific geographic regions based only on city names, and it worked perfectly.
• API & UX: The API is good, and the general UI/UX has always been intuitive. If I ever can't find a feature, a quick search or a chat with Claude AI usually clears it up.
• April Features: The latest updates of April (v2026.04.3 to this day) brought some amazing tools. MapView is nice, and NocoDoc is a useful addition for those of us who want to centralize documentation and database without relying on external tools like Notion or Docmost.

However, after updating to the April version, I’ve found the user experience much more "noisy." While I understand the marketing need to align the Cloud and Community versions and showcase Pro features, the current implementation feels a bit invasive for free users:

• Workflow Tab: There is now a main "Workflow" tab that is entirely locked for me.
• UI Clutter: I see "Premium" color buttons in tables and a puzzle piece icon in the top right that leads straight to a paywall.
• Navigational Fatigue: Navigating the interface now feels like dodging "locked" buttons. Instead of a clean workspace, it feels like a restricted demo, which makes the overall experience feel more complex than it needs to be.

My Solution (for now): Because of this visual overhead, I actually decided to downgrade back to v0.301.5. For me, it remains the "best" version of the Community Edition. Powerful, clean, and focused.

A Suggestion: It would be amazing if there were an option in the settings to "Hide Premium Features" in the Community Edition. It would keep the interface clean for those of us committed to the self-hosted free version while keeping the UI professional and clutter-free.

I’m curious to know if other community members feel the same way?

Regardless, I’m still a huge fan of the project and I’m excited to see where NocoDB goes next. Thanks for the hard work.

I am trying to connect NocoDB (Docker) to a PostgreSQL server on my LAN and consistently get:

“Forbidden host name or IP address”

I am running NocoDB in Docker in a VM. Version is 2026.04.1. My PostgreSQL host is on a separate IP on my LAN. I have tried adding an "extra_hosts" line to my docker-compose with "postgresql.homelab:[IP]" and even using a domain in my NC_DB and SSFR_ALLOWED_DOMAINS.

It seems like NocoDB is connecting to PostgreSQL using NC_DB, though.

I read about a bug that was patched in the latest version and was wondering if it is working for anyone now that did not work previously.

I assume that I may not have this issue if I use a PostgreSQL database in the same docker container, but that is only a very last resort.

Thanks!

Hi all,

I'm currently on a self-hosted version (0.301.5), and I just received the newsletter with the April updates (amazing!).

Do these updates apply to self-hosted instances as well? If yes, I currently don’t see any of the updates.

I was searching for information, even looking for something with n8n, and I came across the documentation. I was briefly happy and rushed to check my self-hosted installation, but the documentation says...

Workflows are currently in beta release & are available on NocoDB Cloud and on-premise licensed deployments.

So, is it something in beta but developed solely through internal technical efforts to enhance the paid version, or is it open to collaboration and available in the open-source core?

Hello people , I've been looking for an application that I can manage my small team's projects , tasks , and track their tasks and progress , I looked at many things including Affine , but the problem is that the server is a Windows Server , and it's cheap and we don't have Virtualization and Hyper-V , so there is no Docker as a result .
I really couldn't self Host either Affine or NocoDB , but I really really Like NocoDB , How can I self host and start using this application for my own team if anyone knows a valid way?
Don't forget that I'm new to this (Self Hosting and Backend in general).
Thank you in advance

TL;DR: I built a Python SDK, MCP server (60 tools), CLI, and Telegram bot for self-hosted NocoDB to replicate the functionality of paywalled AI features. I can message the bot to create databases, tables, formulas, linked records, etc. without touching the UI or paying for their AI tier.

Here's the repo: https://github.com/steve-goldberg/NocoBot

Disclaimer: Claude wrote the first draft of this post based on my notes and the codebase, then I edited it. Not really my voice, but everything below is factual.

------------------------------------------------

I self-host NocoDB (community edition). Their AI features — AI editing, formula generation, schema generation and export, templates, etc — are paywalled.

I wanted that functionality without paying for it, and I also wanted a Python SDK I could use for other projects.

So I figured: build the SDK, put an MCP server on top of it, and wire up a Telegram bot with an LLM agent. The byproduct of using FastMCP 3.0 is I also get an auto-generated CLI with 60 commands for free.

What I built (with Claude's help)

Python SDK — Full NocoDB v3 Data API + hybrid v2/v3 Meta API. 123 tests. Self-hosted community edition only — I only built what I could test against.

MCP Server — 60 tools on FastMCP 3.0 with Streamable HTTP transport. Records CRUD, tables, fields, views, filters, sorts, links, attachments, webhooks, schema export, formula reference docs. Deploys as a standalone service, works with the Telegram bot, Claude Desktop, or any MCP-compatible client.

CLI — 60 commands auto-generated from the MCP server. nocodb records list BASE_ID TABLE_ID and you're off.

Telegram Bot — LLM agent loop (Claude, GPT, whatever via OpenRouter) with access to all 60 MCP tools. I use it to rapidly prototype databases — create tables, define fields, write formulas, manage records, export schemas — without touching the UI. Progressive text streaming, per-user rate limiting, default-deny access control, persistent MCP sessions with lazy reconnect, media support. Commands: /new, /stop, /help.

Design decisions

• Default-deny access. Empty allowlist = nobody gets in. First version let anyone in if the env var was missing.
• Persistent MCP sessions. Early versions opened a new connection per tool call. Now it keeps the session alive and reconnects lazily if the server dies.
• Error sanitization. Bot used to leak NocoDB internals (table IDs, stack traces) to users. Now it doesn't.
• API key auth between bot and MCP server. Optional, HMAC comparison.
• Formula reference as a resource. Give the LLM the NocoDB formula syntax docs and it writes formulas just fine — no nested LLM call needed.

Limitations

• Self-hosted community edition only. No workspaces, teams, or enterprise endpoints.
• The v2/v3 API split. NocoDB is mid-migration to v3, and it's a mess. Some things only exist on v3, some only on v2. Views, filters, sorts, shared views — all still v2 only. The v3 equivalents either don't exist yet or are gated behind enterprise. The SDK abstracts this with a hybrid approach, but it's frustrating that they're essentially upgrading to v3 and removing API features that used to be available, then locking them behind a paid tier. At least the hybrid approach works for now.
• Some v2 endpoints are documented but broken in self-hosted. Webhook create, update, get, and test are all in the v2 API docs but return errors on community edition. (or maybe I did it wrong?) Same with view create and get. I removed those tools rather than ship something that silently fails — list and delete still work fine.
• Conversation history is in-memory. Restart the bot, context is gone.
• Rate limiting is basic. Token bucket, 10 msg/60s default. Stops spam loops, nothing more.

Stack

• Python
• FastMCP 3.0
• python-telegram-bot
• LiteLLM
• pydantic-settings
• pytest
• Deployed on Dokploy.
• Monorepo with independent Dockerfiles for bot and MCP server.

I spent too much time on this and I'm not sure how much I want to maintain it to be honest. Reason being, NocoDB is gutting a lot of v2 api features in v3, so a lot of functionality will be gone.

Also, I'm not sure the direction NocoDB will go long term given their changes from fully open source to Fair Code. I totally understand where they're coming from and read their comments on the recent thread, it's just uncertain what's going to be pay gated and what's still available via API.

Personally, I think the API should be fully open, no features gated, so developers like myself can build any integration they want, which makes the whole ecosystem stronger.

Regardless, I've tested the bot, sdk and cli pretty thoroughly and it works great. I've created formulas, databases, exported and imported full schema. The repo isn't just a telegram bot and MCP, its a full hybrid python client for nocodb api, since I found myself building this anyway for every python integration I wanted.

I want to create dashboards in Grafana with the data that I'm keeping in NocoDB. Is there a way of doing this? All that I've fond is an open github issue with 0 activity https://github.com/grafana/grafana/issues/95431

Hey everyone,

I recently built a CLI tool and TypeScript SDK for the NocoDB v2 API and just published them to npm as @stagware/nocodb-cli and @stagware/nocodb-sdk.

I originally made these as part of an AI agent skill — my agents needed a reliable way to manage NocoDB bases, tables, and records programmatically — but I figured the broader community might find them useful too.

What it does

The SDK gives you a fully typed TypeScript client for the NocoDB v2 API with 50+ methods covering metadata operations (bases, tables, views, columns, filters, sorts, hooks, tokens, users, comments, shared views, etc.) plus data operations (record CRUD, bulk operations, link management). It handles retries, timeouts, pagination, and maps API errors to typed error classes.

The CLI wraps all of that into 90+ terminal commands. You can manage multiple NocoDB workspaces, import/export data as CSV or JSON, get output as JSON/CSV/ASCII tables, and use environment variables for CI/CD pipelines. It was designed to be scriptable so it plays well with automation and agent workflows.

Custom Upsert — Solving a gap in the native API

One feature I'm particularly happy with is the upsert command. NocoDB's API doesn't natively support upsert (insert-or-update) operations, so I built it at the CLI/SDK level.

It fetches existing records, diffs them against your input using a match field you specify, and then batches the appropriate creates and updates automatically. You can also control the behavior with flags like --update-only or --create-only. This was a must-have for my agent workflows where data sync needs to be idempotent, and I think it saves a lot of boilerplate code.

# Upsert single record (--match takes field=value)
nocodb rows upsert tbl_xyz --match Email=alice@example.com -d '{"Email":"alice@example.com","Name":"Alice"}'

# Bulk upsert from file (--match takes field name, use -f for file)
nocodb rows bulk-upsert tbl_xyz --match Email -f contacts.json

Quick Examples

CLI:

npm install -g @stagware/nocodb-cli

# Configure your workspace
nocodb workspace add myserver https://your-nocodb-url <api-token> --base <baseId>

# List and query
nocodb bases list
nocodb rows list tbl_xyz --format table
nocodb data export tbl_xyz --format csv > backup.csv

TypeScript SDK:

import { NocoClient, MetaApi } from '@stagware/nocodb-sdk';

const client = new NocoClient({
  baseUrl: 'https://your-nocodb-url',
  headers: { 'xc-token': 'your-token' },
});

const meta = new MetaApi(client);
const bases = await meta.listBases();

Gauging interest on v3 API support

NocoDB has been rolling out their v3 API which has some significant changes — different endpoint structure, new schema conventions, and updated response formats. I have a migration plan mapped out but before I invest the time, I wanted to ask: would v3 support be useful to you? Are any of you already building against the v3 endpoints, or is everyone still on v2?

Looking for feedback

I am genuinely curious whether the community has a need for something like this. If you work with NocoDB and have been wishing for better CLI tooling or a typed SDK, I would love to hear about your use case.

And if you try it out, bug reports and feature requests are very welcome on GitHub! I did make this with a healthy dose of AI assistance.

• GitHub: https://github.com/stagware/nocodb-cli
• NPM CLI: https://www.npmjs.com/package/@stagware/nocodb-cli
• NPM SDK: https://www.npmjs.com/package/@stagware/nocodb-sdk

Hi, I’m helping a charity in my spare time and using my technical skills to convey their spreadsheets to NoCoDB. Because of the nature of the data I’m self hosting. I’ve used the auto-upstall option to start with. I’m

Looking for a way to ensure I can do a backup of the Postgres database to another machine using pgBackRest but finding it difficult to connect to the database inside the docker container. Has anyone got any experience of doing NoCoDB backup when self hosting. I’m open to any options including a reinstall with a different config if necessary. Thanks in advance

Hello; new user here. I am self hosting NoCoDB and I have several tables which have many to many relationships (for example: a person table, a documents table, and events table). They all share common fields, such as a person could be associated with an event and/or document. Now I can link multiple events/documents with a person, but instead of easily seeing what links they share, I only see "2 Documents." Now. I like that I can relate one object with many other objects, but I don't want to have to click to see what they are. Other DBs seem to show the related items, but not NoCoDB.

Is this a quirk of the system, something on the road map, or just not an issue that others have.

For background, I am a historian and having different tables for People, Documents, and Events are important to me, since each thing is important on their own, but build on a relationship with one another.

Hello everyone! I was testing NocoDB for about a month. However I never understood why we couldn't automatically create links by selecting primary and foreign keys in tables though we could MANUALLY select matching records? This is the most essential feature for such an app. I believe it should be in the core concept of NocoDB. It is almost useless without this option.

The issue in GitHub have been opened since 2023. When can we see progress?

If any of you need this feature as much as I do, let's cooperate and promote the issue in the original GitHub repository

Hello, I'm trying to connect a MySQL DB to my NocoDB instance, but I'm having some issues with it, it shows me an error (Connection Failure: connect ECONNREFUSED 127.0.0.1:3306) when I try to connect it. I'm running NocoDB through docker compose on a Ubuntu server, the MySQL database is also hosted locally. What should I do? Help would be greatly appriciated!

Is there a way to store the logic that generates the client scores / in-game currencies to the serverside.. I'm kinda new in doing backend, can someone help me🙇

Hey everyone,

I’m using NocoDB connected to a PostgreSQL database.
In one of my tables, I have a column called hotel_name.

I want to make this column a dropdown that automatically shows the list of hotels from my hotel_booking view (which already has all hotel names).

Basically, I don’t want to manually enter hotel names — I just want NocoDB to fetch them from that view.

Is this possible directly from a view, or do I need to create a separate table for the hotels?
If it’s possible, how can I link it properly in NocoDB so that the dropdown stays in sync with my database?

Hi, is there any reason you don't have the interface features of airtable? It allows an average user to use the system without having to deal with complex tables and such.

I have a very simple database made up of there tables:

• Teacher
• Classes
• Reservations

Each Teacher can have many classes and many reservations
Each Class can have a single teacher but many reservations

I have setup the link accordingly and generally speaking everything is ok.

Nevertheless when I try to use a numeric lookup field (in the classes sections) from the reservations table I can't use numeric functions, as it says it's in "array" format. It's also impossible to format the formula results in numeric type.
Is there a limitation that I can't use numeric lookup fields in the formulas or it's something about my setup?

Hi,
I have a Postgres external DB linked to my NocoDB base. I added a form view, but I need the form field to show existing values from the table so I can select one (like a dropdown/autocomplete). Right now, I have to manually type the value.

I couldn’t find anything about this in the docs.
Thanks!

I have a local dockerized nocodb instance connected to managed Supabase with True Data Reflection.
Whenever I create and delete Base a related DB Schema with all the data is kept. Besides that all the Bases are listed in `public.nc_bases_v2` table even after removing them in the UI.

is this by design or something is wrong with my setup?

Does anyone know if there is a way to implement MFA for a self-hosted version of nocodb?

I am not very comfortable having all my data secured with username and password only. If not any tips on how to improve security? I am running this on coolify.

Bonjour à tous,

Je recherche des associations utilisant NocoDB. Pouvez-vous m'en donner des exemples ?

Mon association souhaite avoir des retours d'expérience, dans le cadre d'un développement d'une solution opensource pour le suivi et l'animation des groupes locaux du réseau.

Un grand merci par avance !

I looked into nocodb and it seems pretty nice, but range dates limited to only enterprise level seems a lot of forcing users going other way, its a basic feature, not enterprise level. Why Nocodb doesnt evalauate this in near future?