# AI use cases for Nocodb (nocodb/nocodb)

Repo: [nocodb/nocodb](https://github.com/nocodb/nocodb) | Use cases: 3 | Page: https://dedupedai.com/use-cases/nocodb-nocodb/

NocoDB is a free, self-hostable Airtable alternative that turns a database into a spreadsheet interface. It offers Grid, Gallery, Form, Kanban and Calendar views, roles based access control, shareable views, an App Store of chat, email and storage integrations, and REST APIs plus an SDK for programmatic access.

This file holds every use case of this repo. Each one starts with a "## " heading and ends with its URL.

- Self-host an Airtable alternative in one Docker command: https://dedupedai.com/use-cases/nocodb-nocodb/self-host-an-airtable-alternative-with-nocodb/
- Run NocoDB on PostgreSQL for a team tracker: https://dedupedai.com/use-cases/nocodb-nocodb/run-nocodb-on-postgres-with-kanban-and-forms/
- Read and write NocoDB records from scripts: https://dedupedai.com/use-cases/nocodb-nocodb/automate-records-with-the-nocodb-rest-api/

## How to self-host an Airtable alternative in one Docker command with Nocodb

Repo: [nocodb/nocodb](https://github.com/nocodb/nocodb) | Difficulty: Beginner | Time: 15 minutes | Basis: From the README

Start NocoDB with SQLite in Docker and get a spreadsheet style database at localhost:8080.

**Who it is for:** An operator who wants shared tables without a per-seat SaaS bill.

**The problem:** Spreadsheets break down when several people edit structured data at once.

**The outcome:** NocoDB running on your machine with data persisted in a local Nocodb folder.

### Steps

1. Install Docker
2. Run the Docker with SQLite command from the README: `docker run -d` with `--name noco`, `-v "$(pwd)"/nocodb:/usr/app/data/` and `-p 8080:8080`, using the image `nocodb/nocodb:latest`
3. Open http://localhost:8080/dashboard
4. Create a base and tables in the Grid view

### Prompt to paste into your agent

```text
Using nocodb/nocodb, start it with the README's Docker with SQLite command (`--name noco`, `-p 8080:8080`, image `nocodb/nocodb:latest`) and confirm the dashboard loads at localhost:8080.
```

### Caveat

For quick local tests only, the README also lists binaries such as `curl http://get.nocodb.com/linux-x64 -o nocodb -L && chmod +x nocodb && ./nocodb`.

Disclaimer: Third-party repos we don't own or vouch for. AI-generated use cases can be wrong: review everything and run at your own risk. Full text: https://dedupedai.com/disclaimer/

URL: https://dedupedai.com/use-cases/nocodb-nocodb/self-host-an-airtable-alternative-with-nocodb/

## How to run NocoDB on PostgreSQL for a team tracker with Nocodb

Repo: [nocodb/nocodb](https://github.com/nocodb/nocodb) | Difficulty: Intermediate | Time: 1 hour | Basis: From the README

Point NocoDB at a PostgreSQL database and give the team Kanban, Form and Calendar views over the same tables.

**Who it is for:** A team lead replacing a messy shared spreadsheet with a real database.

**The problem:** SQLite in a single container is fine for testing but not for a team's production data.

**The outcome:** A NocoDB instance backed by PostgreSQL with views and roles for the team.

### Steps

1. Run PostgreSQL and note its host, user, password and database name
2. Use the Docker with PG command, setting `NC_DB` to your database URL and `NC_AUTH_JWT_SECRET` to your own secret
3. Create Kanban, Form and Calendar views over your tables
4. Use Access Control with Roles and locked views to limit who can edit what

### Prompt to paste into your agent

```text
With nocodb/nocodb, prepare the README's Docker with PG command for my PostgreSQL at <db host and name>, using my own NC_AUTH_JWT_SECRET instead of the sample value, and list the views I should create for a task tracker.
```

### Caveat

The README's Auto-upstall script installs Docker, PostgreSQL, Redis and Traefik with SSL for production, but it runs a remote script with bash, so read it first.

Risk, credentials: The README sample puts a database password and a JWT secret on the command line; replace both with your own values and keep them out of shell history and repositories.

Disclaimer: Third-party repos we don't own or vouch for. AI-generated use cases can be wrong: review everything and run at your own risk. Full text: https://dedupedai.com/disclaimer/

URL: https://dedupedai.com/use-cases/nocodb-nocodb/run-nocodb-on-postgres-with-kanban-and-forms/

## How to read and write NocoDB records from scripts with Nocodb

Repo: [nocodb/nocodb](https://github.com/nocodb/nocodb) | Difficulty: Intermediate | Time: 1 hour | Basis: From the README

Use NocoDB's REST APIs or SDK with a token to feed rows from other tools and send updates out through Slack or email integrations.

**Who it is for:** A developer wiring a NocoDB base into other automations.

**The problem:** Manual copy and paste between tools and the table causes stale data.

**The outcome:** Scripts that create and update rows, with notifications through App Store integrations.

### Steps

1. Start NocoDB with the Docker with SQLite command and create your base
2. Create a token (JWT or Social Auth) to sign API requests
3. Call the REST APIs or the NocoDB SDK to create, read, update and delete rows
4. Connect Slack or SMTP from the App Store so changes can notify the team

### Prompt to paste into your agent

```text
Using nocodb/nocodb, write a script that signs requests with my NocoDB token and upserts rows from <my CSV> into table <table name> through the REST APIs, then explain how to add a Slack notification from the App Store.
```

### Caveat

The README only names the REST APIs and SDK; endpoint details are in the NocoDB docs.

Risk, credentials: An API token can change every record it can reach; store it in a secret manager, not in the script.

Disclaimer: Third-party repos we don't own or vouch for. AI-generated use cases can be wrong: review everything and run at your own risk. Full text: https://dedupedai.com/disclaimer/

URL: https://dedupedai.com/use-cases/nocodb-nocodb/automate-records-with-the-nocodb-rest-api/