# NocoAI > Part of the NocoDB documentation (Product docs). 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 Last updated: 2026-10-05 NocoAI is the AI assistant built into NocoDB. Ask it in plain language to build bases, tables, views and dashboards, or to find, analyze and update your data. **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. 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](/docs/apps). * **Write docs**: create and edit [NocoDB Docs](/docs/product/docs) pages, and reply to comments. For the full list, and for what NocoAI cannot do yet, refer to [What NocoAI can do](/docs/product/noco-ai/capabilities). ## 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](/docs/product/noco-ai/create-base)**: generate a base from a prompt when you create one. * **[Table suggestions](/docs/product/noco-ai/create-table)**: get new tables that fit your existing schema. * **[Field suggestions](/docs/product/noco-ai/create-field)**: get relevant fields for the table that you edit. * **[View suggestions](/docs/product/noco-ai/create-view)**: get views that fit the content of a table. * **[Filter from a prompt](/docs/product/noco-ai/create-filter)**: describe the records that you want to see. * **[Select option suggestions](/docs/product/noco-ai/create-options)**: get options based on a field's name. * **[Formula from a prompt](/docs/product/noco-ai/create-formula)**: describe the calculation that you need. ## 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 - [What NocoAI can do](https://nocodb.com/docs/product/noco-ai/capabilities.md): The full list of actions that the NocoAI assistant can do in NocoDB, the role each action needs, and what NocoAI cannot do yet. - [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.