# 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-09-25 NocoAI is the AI assistant built into NocoDB. Ask it in plain language to build bases, tables, views and dashboards, or to find, analyse 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, answers questions about your data, updates records, and sets up dashboards, workflows and interfaces. Open it from 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 and 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, grouping and row colours. * **Work with records**: find, count and summarise records, and create, update, link or delete them 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. * **Write docs**: create and edit [NocoDB Docs](/docs/product/docs) pages and reply to comments. See [What NocoAI can do](/docs/product/noco-ai/capabilities) for the full list, including what it can't do yet. ## How NocoAI works * **It knows where you are.** NocoAI sees the table, view, dashboard, doc or record you have open, so "sort this view by date" works without naming the view. You can also `@`-mention a table. * **It shows its steps.** Each action appears in the chat as a step you can expand to see what NocoAI sent and what came back. * **It asks before destructive actions.** Deleting a table, field, view, record, dashboard, doc or interface, and publishing a workflow, waits for you to click **Approve**. * **It follows your role.** NocoAI can only do what your base role allows. A viewer can ask questions about data; changing the structure of a base needs the Creator role. * **It accepts files.** Attach up to 5 files (10 MB each), such as CSV, Excel, JSON, PDF or images, to import or analyse them. ## 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 Besides the assistant, NocoAI also powers AI suggestions inside NocoDB's 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 you're editing. * **[View suggestions](/docs/product/noco-ai/create-view)**: get views tailored to a table's content. * **[Filter from a prompt](/docs/product/noco-ai/create-filter)**: describe the records 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 you need. ## 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 - [What NocoAI can do](https://nocodb.com/docs/product/noco-ai/capabilities.md): The full list of actions the NocoAI assistant can take in NocoDB, the role each one needs, and what NocoAI cannot do yet. - [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.