# 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-09-25
The full list of actions the NocoAI assistant can take in NocoDB, the role each one needs, and what NocoAI cannot do yet.
NocoAI acts with your permissions. Each action below lists the minimum base role it needs; actions your role doesn't allow are not offered to you. Actions marked **Asks first** wait for you to click **Approve** before 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 | Changing the type can lose data that doesn't 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, grouping and row colours |
| 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 summarise 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 | Removing asks first |
| Delete a dashboard | Creator | Asks first |
## Workflows and interfaces
| Action | Minimum role | Notes |
| ----------------------------------------- | ------------ | --------------------------------- |
| Build or edit a workflow | Editor | New workflows are saved 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 can answer questions about NocoDB itself, using this documentation. For billing, account problems or bugs, it points 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 something it changed, but deleted tables, fields, views and records can't be restored this way.
NocoAI is not available on mobile, and it needs a role on the base: people who only have access to an interface can't use it.
## Availability
* NocoAI is available on **NocoDB Cloud** (Plus plan and above), where usage is metered by [credits](/docs/product/workspaces/credits) included monthly with your plan. On self-hosted deployments, AI requires configuring your own AI integration (Business plan and above).
---
## Related pages
- [Create Base Using AI](https://nocodb.com/docs/product/noco-ai/create-base.md): Quickly generate a fully-structured base using natural language prompts with NocoAI
- [Create Tables Using AI](https://nocodb.com/docs/product/noco-ai/create-table.md): Use NocoAI to auto-generate tables and relationships based on natural language prompts.
- [Create Views Using AI](https://nocodb.com/docs/product/noco-ai/create-view.md): Learn how to auto-generate useful views for your table using NocoAI.
- [Filter Records Using AI](https://nocodb.com/docs/product/noco-ai/create-filter.md): Use natural language to filter your table data with NocoAI.
- [Create Fields Using AI](https://nocodb.com/docs/product/noco-ai/create-field.md): Automatically generate relevant fields for your tables using NocoAI.
- [Create Options Using AI](https://nocodb.com/docs/product/noco-ai/create-options.md): Automatically generate field options for select fields using NocoAI.
- [Generate Formulas Using AI](https://nocodb.com/docs/product/noco-ai/create-formula.md): Use natural language prompts to generate formulas with NocoAI.