Baserow MCP Server – Connect AI Assistants to Your Database

Connect AI assistants to your Baserow databases using the Model Context Protocol (MCP). The Baserow MCP server lets you use ChatGPT, Claude, Cursor, Windsurf, and other MCP-compatible AI tools to search, read, create, update, and delete database records using natural language.

Whether you want to query a database with ChatGPT, manage records with Claude, or work with your data through Cursor, Baserow MCP provides a direct connection between your database and AI tools.

You don’t need to write SQL queries or build custom API integrations to get started.

Integrate Baserow with AI assistants using the Model Context Protocol (MCP) Server

What is the Baserow MCP Server?

The Model Context Protocol (MCP) is an open standard that allows AI applications to connect to external tools, databases, and services.

Baserow’s native MCP server connects AI assistants directly to your Baserow workspaces. Once connected, an AI assistant can discover your databases, inspect table schemas, search records, and create, update, or delete rows based on your instructions.

Instead of manually navigating tables or writing API requests, you can describe what you want to do in natural language.

For example, you can ask an AI assistant to:

  • Find all projects that are overdue and show their current status.
  • Add a new task to your project management database.
  • Update the status of tasks assigned to a particular team member.
  • Find customer records that match specific criteria.
  • Summarize your sales pipeline using existing database records.

How does Baserow MCP work?

The Baserow MCP server acts as a connection between your Baserow workspace and an AI assistant.

When you send a request, the assistant uses the available MCP tools to discover your database structure, retrieve relevant records, and perform the requested operations.

There are two ways to connect Baserow to an AI assistant:

Direct integrations

Connect Baserow through an AI assistant’s app or connector directory. Sign in with your Baserow account, select a workspace, and choose which tools the assistant can use.

Baserow currently offers direct integrations with:

  • ChatGPT
  • Claude

Custom MCP connections

Connect Baserow to other MCP-compatible applications, such as Cursor and Windsurf, using an MCP server URL and the configuration required by your AI client.

What can you do with Baserow MCP?

Baserow MCP supports the following database operations:

Operation Available actions
Discover databases List databases and tables
Inspect database structure Retrieve table schemas and field definitions
Read data Search, retrieve, and paginate through table rows
Create data Create new rows
Update data Modify existing rows
Delete data Delete rows from tables

The current row-management integration can read database, table, and field information, but it only changes rows. You cannot create or modify databases, tables, or fields through these tools.

Deleted rows go to Baserow’s trash, where they can be restored for three days by default.

Security and permissions

Baserow MCP uses authentication and workspace-level access to control how AI assistants interact with your data.

When connecting through the direct ChatGPT or Claude integrations:

  • Workspace selection: Each connection is associated with one Baserow workspace.
  • Granular permissions: Choose which tools the assistant can use.
  • Read-only by default: Only read tools are selected by default. You can enable additional permissions when connecting.
  • User authentication: Sign in with your Baserow account to authorize access to your selected workspace.

The assistant can only use the tools and workspace authorized during sign-in.

For custom MCP connections, access is managed through the endpoint configuration and authentication method. Treat your MCP URL as a credential and store it securely.

Only grant permissions required for your intended use case. Review the permissions before authorizing a connection, particularly when enabling operations that modify or delete records.


Connect Baserow to ChatGPT

Connect your Baserow workspace to ChatGPT using the Baserow app. Once connected, ChatGPT can access your authorized workspace and help you search, create, update, and delete records using natural language.

You don’t need to configure an MCP endpoint manually or write JSON configuration.

Prerequisites

  • An active Baserow account.
  • Access to the Baserow workspace you want to connect.
  • Access to ChatGPT.

Step 1. Open the Baserow app in ChatGPT

Open the Baserow app in ChatGPT.

Select the option to connect the app.

Step 2. Continue to Baserow

Review the connection details and select Continue to Baserow.

ChatGPT will redirect you to Baserow to authorize the connection.

Step 3. Sign in to your Baserow account

Sign in using your Baserow credentials.

If you are already signed in, you may be redirected directly to the authorization screen.

Step 4. Select a workspace

Choose the Baserow workspace you want to connect to.

Each connection is associated with one workspace. If you need to access another workspace, you will need to establish a separate connection.

Step 5. Review and grant permissions

Choose which tools ChatGPT can use in your workspace.

The authorization screen groups permissions into categories, including:

Databases

  • Read tables and rows.
  • List databases.
  • List applications.
  • List tables.
  • Get table schemas.
  • List rows and views.
  • Create rows.
  • Update rows.
  • Create tables and fields.
  • Update fields.
  • Create views and view filters.
  • Delete rows and fields, where available.

Automations

The authorization screen may also display permissions for reading and managing workflows and workflow nodes.

Only enable the permissions you need. The available tools depend on the capabilities exposed by the connected Baserow integration.

Only read tools are selected by default. You can grant additional permissions depending on what you want ChatGPT to do.

Review your selections and click Allow.

Step 6. Start using Baserow in ChatGPT

After authorization, you’ll be redirected back to ChatGPT.

Your Baserow connection is now available.

You can ask ChatGPT to find information, search records, create new rows, or update existing data, depending on the tools you authorized.

Example prompts:

  • “List all databases in my Baserow workspace.”
  • “Find all tasks that are overdue in my project management table.”
  • “Create a new task called ‘Review the Q4 marketing strategy’ with High priority.”
  • “Find all customers from Germany in my CRM.”
  • “Update the status of task #47 to In Progress.”

Tip: Be specific about the database and table you want to work with. For changes affecting multiple records, ask ChatGPT to show you which rows will be changed before proceeding.


Connect Baserow to Claude

Connect your Baserow workspace to Claude using the Baserow connector in Claude’s Connectors Directory.

Once connected, Claude can discover your databases, inspect field definitions, search and retrieve records, and create, update, or delete rows through natural language instructions.

You don’t need to configure a local MCP server or manually add JSON configuration for this direct integration.

Prerequisites

  • An active Baserow account.
  • Access to the Baserow workspace you want to connect.
  • Access to Claude.

Step 1. Open Claude’s Connectors Directory

Open Claude and navigate to Customize → Connectors.

Select the option to browse available connectors.

Find Baserow in the directory.

Alternatively, visit the Claude Connectors Directory and search for Baserow.

Step 2. Connect Baserow

Select the Baserow connector and click Connect.

Claude will display the connector information, including its developer and connection URL.

Baserow is listed as a community connector. Claude displays a notice explaining that community connectors undergo automated reviews but aren’t verified by Anthropic.

Before connecting, check that the connector is published by Baserow and that its connection URL is:

https://api.baserow.io/mcp

Select Connect to continue.

Step 3. Review the connection notice

Claude may display a notification about updates to its Consumer Terms and Privacy Policy.

Review the information and accept the updated terms to continue.

Step 4. Sign in to Baserow

Claude will redirect you to Baserow.

Sign in with your Baserow account to authorize the connection.

Step 5. Select a workspace

Choose the Baserow workspace you want Claude to access.

The connection will be limited to the selected workspace.

Step 6. Choose permissions

Review the available Baserow tools and select which operations Claude can perform.

The authorization screen organizes permissions into categories.

Databases

  • Read tables and rows.
  • Create rows.
  • Update rows.
  • Create tables and fields.
  • Update fields.
  • Create views and view filters.
  • Delete rows and fields, where available.

Automations

The authorization screen may also display permissions for reading and managing workflows and workflow nodes.

The Baserow connector currently exposes the following row-management tools:

  • list_databases
  • list_tables
  • get_table_schema
  • list_table_rows
  • create_rows
  • update_rows
  • delete_rows

Only read tools are enabled by default. Enable additional permissions only if you want Claude to perform those actions.

Click Allow to authorize the connection.

Step 7. Start using Baserow in Claude

Once authorization is complete, Claude will show Baserow as a connected service.

You can now use Claude to interact with your Baserow workspace.

Example prompts:

  • “Show me all databases in my Baserow workspace.”
  • “Find all customers from Germany in my CRM.”
  • “Add a new customer named Acme Corporation to my customers table.”
  • “Update the status of all tasks assigned to me.”
  • “Summarize the projects that are currently in progress.”

Tip: Ask Claude to inspect your table schema before performing operations. This helps it use the correct field names and understand your database structure.


Connect Baserow to other MCP-compatible clients

You can also connect Baserow to AI applications that support custom MCP servers.

This method is useful when your AI client doesn’t offer a direct Baserow integration in its app directory.

Step 1. Create an MCP endpoint in Baserow

  1. Open your Baserow workspace.
  2. Click your workspace name in the top navigation bar.
  3. Select My Settings.
  4. Navigate to the MCP Server tab.
  5. Click Create Endpoint.
  6. Enter a descriptive name for your endpoint, such as “Marketing Database Assistant”.
  7. Select the workspace you want to connect.
  8. Create the endpoint.

Baserow will generate a unique MCP URL for your connection.

Copy the URL and store it securely.

Step 2. Configure your AI client

After creating your endpoint, click More Details to view the available configuration options.

Select your preferred AI client and follow its setup instructions.

Cursor

  1. Open Cursor settings (⇧+⌘+J on Mac).
  2. Navigate to the MCP tab.
  3. Click Add MCP Server.
  4. Add the following JSON configuration:
{
  "mcpServers": {
    "Baserow MCP": {
      "url": "YOUR_MCP_URL_HERE"
    }
  }
}

Replace YOUR_MCP_URL_HERE with the MCP URL copied from your Baserow settings.

Windsurf

  1. Open Windsurf Settings → Advanced Settings (or use Command Palette → “Open Windsurf settings page”).
  2. Scroll to the Cascade section.
  3. Click to add a new server or open the raw JSON configuration file at mcp_config.json.
  4. Add the following configuration:
{
  "mcpServers": {
    "Baserow MCP": {
      "serverUrl": "YOUR_MCP_URL_HERE"
    }
  }
}

Replace YOUR_MCP_URL_HERE with the MCP URL copied from your Baserow settings.

Claude Desktop

  1. Open Claude Desktop settings (⌘+, on Mac).
  2. Navigate to the Develop tab.
  3. Click Edit Config to open claude_desktop_config.json.
  4. Add the following JSON configuration:
{
  "mcpServers": {
    "Baserow MCP": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "YOUR_MCP_URL_HERE"
      ]
    }
  }
}

Replace YOUR_MCP_URL_HERE with the MCP URL copied from your Baserow settings.

Step 3. Start using Baserow

Once configured, your AI client can connect to Baserow and use the tools exposed by your MCP endpoint.

Follow your client’s instructions to complete authentication and verify the connection.

Note: Custom MCP configurations and authentication requirements may differ between AI clients. For self-hosted Baserow installations, additional MCP authentication configuration may be required.


Available MCP tools

Baserow exposes tools that allow AI assistants to discover database structures and work with records.

Tool Description
list_databases Lists databases available in the connected workspace.
list_tables Lists tables in a database.
get_table_schema Retrieves a table’s fields and their definitions.
list_table_rows Searches and retrieves rows from a table.
create_rows Creates new rows in a table.
update_rows Updates existing rows.
delete_rows Deletes rows from a table.

How AI assistants should work with Baserow data

For reliable results, an AI assistant should follow this sequence:

  1. Call list_databases to find the available databases.
  2. Call list_tables to identify the relevant table.
  3. Call get_table_schema to understand the table’s fields.
  4. Use list_table_rows to retrieve relevant records.
  5. Create, update, or delete rows only after identifying the correct records and confirming the intended changes with the user.

Use the database and table IDs returned by the discovery tools. Never guess IDs or field names. Use field names exactly as returned by the table schema.

Searching and retrieving rows

Use list_table_rows with a search term instead of retrieving an entire table whenever possible.

The tool returns:

  • count: The total number of matching rows.
  • A page containing up to size rows.
  • A default page size of 100 rows and a maximum of 200 rows.

If the total number of matching records is larger than the number returned, retrieve subsequent pages or narrow the search before concluding that a record doesn’t exist.

Search may not cover link-to-table, boolean, collaborator, and duration fields. If searching for these values returns no results, retrieve the relevant rows and compare the field values directly.

Updating and deleting rows

Before using update_rows or delete_rows, the assistant should show you which rows will be affected.

Large changes should be processed in batches of no more than 200 rows.

Deleted rows go to Baserow’s trash, where they can be restored for three days by default. There is no undo tool available through the MCP connection.

Limitations

The current row-management tools can read database structures and manage rows, but they cannot:

  • Create or modify databases.
  • Create or modify tables.
  • Create or modify fields.
  • Create or modify views through the row-management tools.

Use the Baserow interface to make structural changes to your databases.


Security best practices

Your Baserow MCP connection gives an AI assistant access to the tools and workspace you authorized. The level of access depends on the connection method and permissions you grant.

For custom MCP endpoints, your MCP URL contains credentials that grant access to the endpoint.

Do:

  • Store your MCP URL securely, like a password.
  • Revoke and regenerate endpoints if their URLs are compromised.
  • Use descriptive endpoint names to track connections.
  • Create separate endpoints for different use cases when appropriate.
  • Review permissions before connecting an AI client.

Don’t:

  • Share your MCP URL publicly or in version control.
  • Store it in unsecured locations.
  • Post screenshots containing the full URL.
  • Grant unnecessary write or delete permissions.

For direct ChatGPT and Claude integrations, manage authorization through the connected app and your Baserow MCP settings.


Troubleshooting

My databases are not showing up

If list_databases returns no results, the connection may point to a workspace that doesn’t contain any databases.

Check that you selected the correct workspace when authorizing the connection.

The AI assistant cannot create or update records

Check the permissions you granted when connecting Baserow.

If the required row tool wasn’t authorized during sign-in, you need to authenticate again and enable the relevant permission.

For direct ChatGPT and Claude connections, a plain reconnect may retain the previous authorization.

To change the workspace or permissions:

  1. Disconnect the Baserow integration under My Settings → MCP Server in Baserow.
  2. Open the connected apps or connectors settings in your AI assistant.
  3. Reconnect Baserow.
  4. Select the workspace and tools you want to authorize.

The AI assistant cannot find a particular record

The list_table_rows tool returns paginated results, so a search may not include every matching record in the first response.

Ask the assistant to check the total number of matching records and retrieve additional pages if necessary.

Some field types, including link-to-table, boolean, collaborator, and duration fields, may not be covered by search. In these cases, the assistant should retrieve the rows and compare the field values directly.

Can I connect multiple Baserow workspaces?

Each connection is associated with one workspace.

To work with multiple workspaces, establish separate connections and authorize each workspace.

Can the AI assistant create tables or fields?

No. The current row-management MCP tools can read database structures and manage rows, but they cannot create or modify databases, tables, or fields.

Use the Baserow interface to make structural changes to your databases.

Can I revoke access?

Yes. You can disconnect direct integrations and manage your MCP connections under My Settings → MCP Server in Baserow.

For custom MCP endpoints, you can delete the endpoint in your Baserow MCP settings. If an endpoint URL is compromised, delete it and create a new one. The old URL will no longer work.

You can also disconnect integrations from your AI assistant’s connected apps or connectors settings.


Frequently asked questions

What is an MCP server?

MCP (Model Context Protocol) is an open standard that allows AI applications to connect to external tools, databases, and services.

An MCP server exposes tools that an AI assistant can use to retrieve information and perform actions in an external application.

What is the Baserow MCP server?

The Baserow MCP server connects AI assistants to Baserow databases. It allows assistants to discover databases, inspect schemas, search records, and create, update, or delete rows using natural language instructions.

Which AI assistants support Baserow MCP?

Baserow offers direct integrations with ChatGPT and Claude. You can also connect Baserow to other MCP-compatible applications, including Cursor and Windsurf, through custom MCP configurations.

Do I need an API token to connect Baserow to ChatGPT or Claude?

No. The direct integrations use your Baserow account to authenticate and authorize access to a selected workspace. You don’t need to manually create an API token or copy an MCP endpoint URL.

Can I use Baserow MCP with self-hosted Baserow?

Yes. Self-hosted Baserow can be connected using a custom MCP server configuration. Your installation must have MCP authentication enabled and be configured to accept connections from the AI client.

See the MCP OAuth setup documentation for configuration details.

Can I use natural language to manage my Baserow databases?

Yes. You can ask an AI assistant to search records, create new rows, update existing information, or delete records using natural language.

The assistant uses your database schema and available MCP tools to translate your instructions into database operations.

Does Baserow MCP support SQL queries?

Baserow MCP uses dedicated tools to interact with your databases rather than requiring you to write SQL queries.

You can describe the information you need in natural language, and the AI assistant can search and retrieve relevant records.

Is Baserow MCP read-only?

No. Baserow MCP supports both read and write operations.

Read-only tools are enabled by default when connecting. You can authorize additional tools to create, update, and delete rows.

Can I use Baserow MCP to automate workflows?

You can use AI assistants to perform data-management tasks through MCP, including creating and updating records.

MCP connects an AI assistant to Baserow; it is not itself an automation workflow engine. For more advanced automated processes, explore Baserow Automations.

Can I create multiple MCP endpoints for different purposes?

Yes. You can create multiple custom MCP endpoints within the same workspace. This is useful for organizing access by project, team member, or use case. Each endpoint has its own URL and access configuration.

What happens if my MCP URL is exposed?

If your custom MCP URL is compromised, immediately delete the endpoint in your Baserow MCP settings and create a new one. The old URL will no longer function.

Do I need programming knowledge to use Baserow MCP?

No. You can describe the database operations you want to perform in plain English. The AI assistant uses the available MCP tools to translate your instructions into database operations.

What are the limitations of using AI to manage database operations?

AI interpretations depend on model quality and prompt clarity. Always verify critical operations, especially bulk updates or deletions.

The current row-management MCP tools support reading database structures and managing rows, but do not support creating or modifying databases, tables, or fields.


Still need help? Visit the Baserow Community or contact our support team.