# Rowflare

> Rowflare is an open-source MCP server for databases. Let an agent query, build and automate Rowflare bases, an open-source Airtable alternative. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Open source
- **Starting price:** $29 a month
- **Platforms:** Web, API, self-hosted
- **Website:** https://rowflare.com/docs/mcp/
- **Repository:** https://github.com/rowflare/rowflare
- **MCP Registry name:** io.github.rowflare/rowflare
- **Categories:** databases, productivity
- **Listing updated:** 2026-11-15

## About

Rowflare's endpoint covers more than record access: an agent can create tables with links, lookups, rollups and formulas, build grid, kanban, calendar, timeline, gallery or form views, assemble dashboards, and define automations. Aggregate queries return grouped totals so an agent does not have to download every record.

Authentication uses personal access tokens, and a token acts as its owner, so viewers in a workspace only get the read tools. Destructive tools are marked, and new automations start switched off. No tool can run an automation.

Every Rowflare instance serves its own /mcp endpoint. Limits include 50 records per query by default (200 at most) and up to 200 records per write call. Rowflare is AGPL-3.0 and can run on Cloudflare Workers.

## Features

- **Record queries:** Filters, sorts and pages through records, or fetches them by id.
- **Grouped totals:** Counts, sums, averages and more, grouped by up to two fields.
- **Schema editing:** Creates and changes tables, fields and views.
- **Dashboards:** Builds metric, bar, line, pie, pivot and text widgets.
- **Automations:** Creates triggered workflows with http, email, AI and branch steps.
- **AI fields:** Queues AI generation for fields using a configured AI service.

## Good for

- Ask for counts and totals from a base without exporting it
- Create a CRM-style table with linked records
- Build a dashboard from existing tables
- Set up an automation that fires when a record reaches a stage
- Bulk-update records from an agent

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http rowflare https://app.rowflare.com/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://app.rowflare.com/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "rowflare": {
      "url": "https://app.rowflare.com/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "rowflare": {
      "type": "http",
      "url": "https://app.rowflare.com/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "rowflare": {
      "serverUrl": "https://app.rowflare.com/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "rowflare": {
      "type": "http",
      "url": "https://app.rowflare.com/mcp"
    }
  }
}
```

## Tools

- `list_bases`: Lists bases you can access.
- `describe_base`: Shows tables, fields, row counts and views.
- `query_records`: Filters, sorts and pages records.
- `get_records`: Fetches records by id.
- `aggregate`: Computes grouped counts, sums and averages.
- `create_records`: Creates records.
- `update_records`: Updates records.
- `delete_records`: Deletes records.
- `create_table`: Creates a table.
- `update_table`: Renames a table or changes its primary field.
- `delete_table`: Deletes a table.
- `create_field`: Adds a field.
- `update_field`: Changes a field.
- `delete_field`: Deletes a field.
- `create_view`: Creates a view.
- `update_view`: Changes a view.
- `list_dashboards`: Lists dashboards.
- `get_dashboard`: Reads a dashboard's widgets and numbers.
- `create_dashboard`: Creates a dashboard.
- `update_dashboard`: Edits dashboard widgets.
- `list_automations`: Lists automations.
- `get_automation`: Shows an automation and its recent runs.
- `create_automation`: Creates an automation.
- `update_automation`: Edits an automation.
- `list_ai_services`: Lists AI services.
- `generate_ai_field`: Queues AI generation for records.

## FAQ

### How does it authenticate?

With a personal access token created in Settings, which acts as you.

### Can viewers write data?

No. In workspaces where you are a viewer, write and schema tools return a read-only error.

### Which tools are destructive?

delete_records, delete_table, delete_field and any update that clears select options or replaces automation steps or widgets are flagged.

### Where is the endpoint?

At /mcp on your own Rowflare instance; the registry lists app.rowflare.com for the hosted cloud.

### Is Rowflare free?

Yes. Rowflare is open source, so you can use and self-host it for free.

### How do I add Rowflare to Claude Code?

Run this command in your terminal: claude mcp add --transport http rowflare https://app.rowflare.com/mcp

### What are the best alternatives to Rowflare?

The closest alternatives to Rowflare are Ha MCP, Concord MCP, Midplane, note1 and CalderFlow.

## Alternatives

- [Ha MCP](https://ai-powered.com/mcp/ha-mcp): Ha MCP is an open-source MCP server for productivity.
- [Concord MCP](https://ai-powered.com/mcp/concord-mcp): Concord MCP is a freemium MCP server for developer tools.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [note1](https://ai-powered.com/mcp/note1): note1 is an MCP server for productivity.
- [CalderFlow](https://ai-powered.com/mcp/calderflow): CalderFlow is a free MCP server for design and media.
- [nicemails](https://ai-powered.com/mcp/nicemails): nicemails is a freemium MCP server for communication.
- [ConvertAudioToText](https://ai-powered.com/mcp/convertaudiototext): ConvertAudioToText is a freemium MCP server for design and media.
- [Hostlet](https://ai-powered.com/mcp/hostlet): Hostlet is a free MCP server for productivity.

---
Source: https://ai-powered.com/mcp/rowflare
