NocoAI

NocoAI is the AI assistant built into NocoDB. You tell it what you want in plain language, and it does the work in your base: it builds tables, fields and views, answers questions about your data, updates records, and sets up dashboards, workflows and interfaces.

Open it from the NocoAI button at the bottom-right of any base in NocoDB.

Ask NocoAI

Copy a prompt, paste it into NocoAI in any base, and replace the words in [brackets] with your own.

Build a base to manage [our sales pipeline], with the tables, links and views it needs
Import the attached file as a new table
Show me the records in this table that were updated in the last [7] days
Build a dashboard that tracks [open tasks by status and assignee]

What you can ask NocoAI to do

Build a base: describe a use case and NocoAI creates the tables, fields, links and views for it. It can create up to 20 related tables in one step.
Change the structure: add, rename, modify or delete tables and fields, including formulas, links, lookups and rollups.
Shape your views: create any view type, show or hide fields, and add filters, sorts, grouping and row colours.
Work with records: find, count and summarise records, and create, update, link or delete them in bulk.
Import files: turn an attached CSV, Excel or JSON file into a new table, or add it to an existing one.
Build dashboards: create a dashboard with charts, metrics and text in one request.
Automate: draft workflows, edit them step by step, and publish them.
Build interfaces: create interface pages for your team, then edit and publish them.
Write docs: create and edit NocoDB Docs pages and reply to comments.

See What NocoAI can do for the full list, including what it can't do yet.

How NocoAI works

It knows where you are. NocoAI sees the table, view, dashboard, doc or record you have open, so "sort this view by date" works without naming the view. You can also @-mention a table.
It shows its steps. Each action appears in the chat as a step you can expand to see what NocoAI sent and what came back.
It asks before destructive actions. Deleting a table, field, view, record, dashboard, doc or interface, and publishing a workflow, waits for you to click Approve.
It follows your role. NocoAI can only do what your base role allows. A viewer can ask questions about data; changing the structure of a base needs the Creator role.
It accepts files. Attach up to 5 files (10 MB each), such as CSV, Excel, JSON, PDF or images, to import or analyse them.

Examples

You ask	NocoAI does
"Add a Priority field with High, Medium and Low"	Adds a single select field with those options
"Show only open tasks due this week that are assigned to me"	Adds the filters to the current view
"How many deals did we close last month?"	Queries the records and answers in the chat
"Mark every task in Review as Done"	Updates the matching records
"Build a sales dashboard for this year"	Creates a dashboard with charts and metrics

AI suggestions in NocoDB

Besides the assistant, NocoAI also powers AI suggestions inside NocoDB's editors:

Create a base with AI: generate a base from a prompt when you create one.
Table suggestions: get new tables that fit your existing schema.
Field suggestions: get relevant fields for the table you're editing.
View suggestions: get views tailored to a table's content.
Filter from a prompt: describe the records you want to see.
Select option suggestions: get options based on a field's name.
Formula from a prompt: describe the calculation you need.

Availability

NocoAI is available on NocoDB Cloud (Plus plan and above), where usage is metered by credits included monthly with your plan. On self-hosted deployments, AI requires configuring your own AI integration (Business plan and above).