What NocoAI can do

NocoAI acts with your permissions. Each action below shows the minimum project role that it needs. NocoAI does not offer actions that your role does not allow, or actions for a feature that your plan does not include.

Actions with the note Asks first wait until you click Approve. Then they run.

Projects and tables

Action	Minimum role	Notes
Build a project from a description	Creator	Creates up to 20 related tables with fields, links and views in one step
Create a table	Creator
Rename a table or edit its description	Creator
Delete a table	Creator	Asks first
Duplicate a table	Creator	Copies its fields, views, data and webhooks
Group tables into folders	Creator
Restore something from the project trash	Editor	Deleted records, tables, views, fields, dashboards and scripts
Rename a project	Owner

Ask NocoAI

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

Build a project to manage [inventory], with linked tables for [products, suppliers and stock movements]
Add a table to this project for [invoices] and link it to [Customers]
Rename this table to [new name] and give it a short description

Fields

Action	Minimum role	Notes
Add a field	Creator	Text, number, currency, percent, rating, duration, date and time, select, checkbox, attachment, user, JSON, barcode, QR code, button and more
Add links, lookups, rollups and formulas	Creator	Describe the relationship or calculation in plain language
Rename a field or change its type	Creator	When you change the type, you can lose data that does not fit the new type
Set the display value	Creator
Duplicate a field	Creator
Delete a field	Creator	Asks first

Views

Action	Minimum role	Notes
Create a view	Creator	Grid, gallery, kanban, calendar, form, timeline, gantt, map and list, with filters, sorts, groups and row colors
Show, hide or reorder fields	Editor
Add or remove filters	Editor
Add or remove sorts	Editor
Group records (up to 5 levels)	Editor	Grid views
Rename a view	Editor
Duplicate a view	Editor
Set or clear row coloring	Editor
Share a view, or stop sharing it	Editor	Asks first
Group views into folders	Creator
Delete a view	Editor	Asks first
Open a table, view or dashboard	Viewer

Ask NocoAI

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

Group this view by [Status] and sort each group by [Due Date]
Hide every field in this view except [Name, Status and Owner]
Create a [calendar] view of this table using [Date]

Records and data

Action	Minimum role	Notes
Find, count and summarize records	Viewer	Includes linked records
Create or update records	Editor	Up to 50 at a time
Link or unlink records	Editor
Delete records	Editor	Up to 10 at a time. Asks first
Import a CSV, Excel or JSON file	Editor	Into a new table or an existing one
Export records to CSV or Excel	Viewer
Read, add, edit and resolve record comments	Commenter
Create records from a record template, and manage the templates	Editor

Ask NocoAI

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

Which [customers] have no [orders] in the last [90] days?
Summarise this table: how many records are there, and how are they spread across [Status]?
Set [Status] to [Done] for every record where [Due Date] has passed

Dashboards

Action	Minimum role	Notes
Build a dashboard with widgets	Creator	Bar, line, pie and donut charts, metrics, text and iframes
Add, edit or remove widgets	Creator	Asks first when you remove a widget
Delete a dashboard	Creator	Asks first

Workflows and interfaces

Action	Minimum role	Notes
Build or edit a workflow	Editor	NocoAI saves new workflows as drafts
Publish a workflow	Editor	Asks first
Write, edit or delete a script	Creator	Deleting asks first
Create, edit or delete a webhook	Creator	Asks first
Group workflows and scripts into folders	Creator
Build an interface, or edit and add pages	Creator
Publish an interface	Creator
Delete an interface or a page	Creator	Asks first

Docs

Action	Minimum role	Notes
Read docs and their comments	Viewer
Create a doc	Creator
Edit a doc	Editor
Add or resolve comments	Commenter
Move a doc	Editor
Share a doc, or stop sharing it	Creator	Asks first
Delete a doc	Creator	Asks first

Members and permissions

Action	Minimum role	Notes
List the members and teams of a project	Viewer	The subjects a permission grant or a policy can name
Grant or drop table and field permissions	Creator	Asks first
Create, edit or delete row-level security policies	Owner	Asks first
Read the project audit log	Owner

Help

NocoAI answers questions about NocoDB. It uses this documentation to find the answers. For billing, account problems or bugs, NocoAI sends you to the NocoDB support team.

What NocoAI can't do yet

Invite people to a project or a workspace, or change someone's role
Set up sync
Create, rename or manage workspaces
Share a project, or create a project share link
Undo with a button. You can ask NocoAI to put back a change that it made, or to restore the change from the project trash.

NocoAI is not available on mobile. To use NocoAI, you need a role on the project. People who only have access to an interface cannot use NocoAI.

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.