# Baserow MCP

> Baserow MCP connects your AI agent directly to your no-code relational database. Manage, query, and update structured data without ever opening a web browser or writing SQL. You tell your AI client what you need—whether it's listing all project applications or updating a user status—and it handles the complex data operations instantly.

## Overview
- **Category:** developer-tools
- **Price:** Free
- **Tags:** no-code, relational-database, data-schema, api-integration, data-orchestration, workspace-management

## Description

You manage your no-code databases conversationally. This MCP gives your agent full control over structured information housed in Baserow, letting you treat your database like an extension of natural language chat. Instead of navigating through menus or copying raw JSON to update records, you simply ask for what you need. Your AI client acts as a dedicated data architect, allowing you to list all connected workspaces and applications, manage fields, and even perform complex searches using semantic keywords across tables.

This capability means no more getting lost in spreadsheet tabs. You can programmatically read specific record details or update an entire row's status just by describing the change. Through Vinkius, your agent gains access to thousands of other tools, making it a central hub for all your structured data needs. Whether you need to create a new project entry, delete old records, or verify account permissions, this MCP handles the underlying complexity so you only deal with the outcome.

## Tools

### list_applications
Shows all distinct Baserow applications (databases) you have set up.

### create_row
Creates a brand new record in any specified table, requiring field names and values as JSON data.

### delete_row
Permanently removes a specific row from a given table.

### list_fields
Retrieves the names and types of all fields available within a chosen table.

### get_row
Fetches detailed data for one specific row, using its unique identifier.

### list_rows
Searches and lists multiple rows in a table; supports pagination and search terms.

### list_tables
Displays all available tables within a selected database application.

### update_row
Modifies the data in an existing row, requiring both the row's identifier and new values as JSON data.

### list_workspaces
Lists every workspace connected to your Baserow account.

## Prompt Examples

**Prompt:** 
```
List all active database applications in my Baserow account.
```

**Response:** 
```
I've retrieved your database directory. You currently have 3 applications: 'Project Tracker' (ID: 123), 'Customer CRM', and 'Inventory'. Which one would you like to explore for tables?
```

**Prompt:** 
```
Show the records in table ID '456' from the 'Customer CRM' database.
```

**Response:** 
```
Accessing records... I found 15 entries in table 456, including @user1 and @user2. I've retrieved their detailed field metadata for you. Shall I filter for a specific record?
```

**Prompt:** 
```
Search for 'John Doe' in table '456'.
```

**Response:** 
```
Searching... I found one match: 'John Doe' (Row ID: 789). His profile includes high-fidelity data like 'Email' and 'Plan Type'. Would you like to update any of these fields?
```

## Capabilities

### Manage Database Structure
List and monitor all workspaces, applications, fields, and tables within your Baserow setup.

### Perform Data Reads (Querying)
Retrieve specific record details or list paginated rows from any table using natural language search criteria.

### Update and Modify Records
Programmatically create new records in a row or modify existing data fields with simple instructions.

### Maintain Data Integrity
Delete specific rows when they are no longer needed, ensuring your data ledger stays clean and accurate.

## Use Cases

### Auditing Project Status
A PM needs to know the status of all marketing assets. Instead of opening 15 different spreadsheets, they ask their agent: 'List all rows in the Assets table where the Owner is Sarah.' The agent executes `list_rows` and returns a clean list.

### Onboarding New Vendors
A data analyst needs to input 20 new vendor records. They ask: 'Create 20 rows in the Vendor database with these JSON details.' The agent uses `create_row` repeatedly, saving hours of manual work.

### Troubleshooting Data Errors
A developer notices a row is missing key data. They ask: 'What are the current fields in the CRM table?' The agent runs `list_fields`, confirming if the required field even exists before attempting an update.

### Cleaning Up Old Data
A team lead needs to archive old project data. They ask: 'Delete all rows in the Project table where the completion date is over two years ago.' The agent runs `delete_row` safely, cleaning up the ledger.

## Benefits

- Stop manual data entry. Instead of clicking through forms to update a project status, simply ask your agent to 'Update the row for Project Alpha to Status: Complete.'
- Build custom workflows without code. Use the `create_row` tool to programmatically generate new records—like onboarding a new client or adding inventory items—using natural language prompts.
- See exactly what you're working with. The agent can use `list_fields` to show you every available data point in a table, helping you understand the schema before you write a query.
- Never lose track of your systems again. Use `list_workspaces` or `list_applications` to get an instant directory of every database managed under your account.
- Search smarter, not harder. The agent uses semantic search via `list_rows`, letting you find records based on keywords rather than needing exact IDs or complex filters.

## How It Works

The bottom line is you get conversational control over complex database structures without needing any API keys or technical knowledge.

1. First, subscribe to the Baserow MCP on Vinkius. Then, copy your Database Token from your Baserow settings.
2. Paste that token into your AI client and authorize access. Your agent now has permission to interact with all your structured data.
3. Finally, give your agent a command—like 'List all project applications' or 'Update John Doe’s status to Complete.' It executes the action and returns the result.

## Frequently Asked Questions

**How do I check which databases Baserow MCP can access?**
You use the `list_workspaces` tool. This command provides an overview of every high-level workspace connected to your account, letting you know what systems are available for management.

**Can I read data from multiple tables at once using Baserow MCP?**
Yes, by combining tools. You first use `list_tables` to identify all relevant sources, and then ask your agent to run `list_rows` against each table you need.

**What if I don't know the ID of a row I want to update?**
You can use `list_rows` first. By providing search criteria (like 'Project Name: Alpha'), the agent will find the matching records and give you the necessary IDs before you run `update_row`.

**Does Baserow MCP support large data sets?**
Yes, the tools are designed for scale. The `list_rows` tool specifically supports pagination and search, meaning it can handle listing many records without timing out.