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. It answers questions about your data and updates records. It also sets up dashboards, workflows and interfaces.

To open NocoAI, click 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. 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, groups and row colors.
Work with records: find, count and summarize records. Create, update, link or delete records 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.
Build apps: describe a work app, and NocoAI builds an enterprise-grade app on your data in NocoDB's AI app builder.
Write docs: create and edit NocoDB Docs pages, and reply to comments.

For the full list, and for what NocoAI cannot do yet, refer to What NocoAI can do.

How NocoAI works

It knows where you are. NocoAI sees the table, view, dashboard, doc or record that you have open. So "sort this view by date" works, and you do not have to name the view. You can also @-mention a table.
It shows its steps. Each action shows in the chat as a step. Expand the step to see what NocoAI sent and what came back.
It asks before destructive actions. Before NocoAI deletes a table, field, view, record, dashboard, doc or interface, it waits until you click Approve. It also waits before it publishes a workflow.
It follows your role. NocoAI can only do what your base role allows. A viewer can ask questions about data. To change the structure of a base, you need the Creator role.
It accepts files. Attach up to 5 files (10 MB each) to import or analyze them. For example: CSV, Excel, JSON, PDF or images.

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

NocoAI also gives AI suggestions inside the NocoDB 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 that you edit.
View suggestions: get views that fit the content of a table.
Filter from a prompt: describe the records that you want to see.
Select option suggestions: get options based on a field's name.
Formula from a prompt: describe the calculation that you need.

Availability

NocoAI is available on NocoDB Cloud (Plus plan and above). On Cloud, NocoAI uses credits. Your plan includes credits each month.
On self-hosted deployments (Business plan and above), you must configure your own AI integration to use AI.