# What NocoAI can do
> Part of the NocoDB documentation (Product docs > NocoAI). Index of all pages: https://nocodb.com/llms.txt. Any docs page is available as Markdown by adding `.md` to its URL.
URL: https://nocodb.com/docs/product/noco-ai/capabilities
Last updated: 2026-10-03
The full list of actions that the NocoAI assistant can do in NocoDB, the role each action needs, and what NocoAI cannot do yet.
NocoAI acts with your permissions. Each action below shows the minimum base role that it needs. NocoAI does not offer actions that your role does not allow.
Actions with the note **Asks first** wait until you click **Approve**. Then they run.
## Bases and tables
| Action | Minimum role | Notes |
| -------------------------------------- | ------------ | ------------------------------------------------------------------------ |
| Build a base 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 |
| Rename a base | Owner | |
Build a base to manage [inventory], with linked tables for [products, suppliers and stock movements]
Add a table to this base 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 | |
| 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 3 levels) | Editor | Grid views |
| Rename a view | Editor | |
| Delete a view | Editor | Asks first |
| Open a table, view or dashboard | Viewer | |
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 |
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 |
| 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 | |
| Delete a doc | Creator | Asks first |
## 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
* Manage members, roles or permissions
* Set up sync, webhooks or scripts
* Create, rename or manage workspaces
* Share bases or views, or create share links
* Comment on records (it can comment on docs)
* Undo with a button. You can ask NocoAI to put back a change that it made. This does not restore deleted tables, fields, views or records.
NocoAI is not available on mobile. To use NocoAI, you need a role on the base. 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](/docs/product/workspaces/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.
---
## Related pages
- [Create Base Using AI](https://nocodb.com/docs/product/noco-ai/create-base.md): Generate a complete NocoDB base with tables, views, fields and relationships from a plain-language prompt with NocoAI.
- [Create Tables Using AI](https://nocodb.com/docs/product/noco-ai/create-table.md): Generate NocoDB tables and their relationships from plain-language prompts with NocoAI.
- [Create Views Using AI](https://nocodb.com/docs/product/noco-ai/create-view.md): Generate useful views for a NocoDB table with NocoAI.
- [Filter Records Using AI](https://nocodb.com/docs/product/noco-ai/create-filter.md): Filter NocoDB table records with a plain-language description through NocoAI.
- [Create Fields Using AI](https://nocodb.com/docs/product/noco-ai/create-field.md): Generate relevant fields for a NocoDB table from a description with NocoAI.
- [Create Options Using AI](https://nocodb.com/docs/product/noco-ai/create-options.md): Generate options for NocoDB Single Select and Multi Select fields with NocoAI.
- [Generate Formulas Using AI](https://nocodb.com/docs/product/noco-ai/create-formula.md): Generate NocoDB formulas from plain-language prompts with NocoAI.