Skip to content
MCP server

Rowflare

Let an agent query, build and automate Rowflare bases, an open-source Airtable alternative

Install
Pricing
Open source
Platforms
Web, API, self-hosted
Runs
Remotely
Version
0.1.0
Listing updated
2 days ago

About Rowflare

Rowflare is an open-source MCP server for databases. It runs as a hosted remote server, so there is nothing to install locally.

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.

Install

Run in a terminal

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

Add to Settings → Connectors → Add custom connector

https://app.rowflare.com/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "rowflare": {
      "url": "https://app.rowflare.com/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Tools this server provides (26)

Taken from the project documentation; the running server may differ.

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.

What it does

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

Pricing

Open source, from $29 a month

Self-hosted free (AGPL-3.0); Cloud paid $29 per workspace per month

Prices change. Check rowflare.com before you buy.

Rowflare 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 to Rowflare

  1. Ha MCP

    MCP server

    MCP server for managing and automating Home Assistant from AI assistants

    Runs locally
    • 8 tools
    • Open source
    • 7.9K GitHub stars
    • Productivity
  2. Concord MCP

    MCP server

    Local-first MCP server for messaging and shared work-state between coding agents

    Runs locally
    • Freemium
    • 1.3K GitHub stars
    • Developer tools
  3. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  4. note1

    MCP server

    MCP server giving AI assistants search and summaries across your note1 meetings

    • 4 tools
    • Remote
    • Free trial
    • 1 GitHub star
    • Productivity
  5. CalderFlow

    MCP server

    Turn notes or specs into editable flowcharts, timelines and funnels from an AI assistant

    • 10 tools
    • Remote
    • Free
    • Design and media
  6. nicemails

    MCP server

    Give each AI agent its own real mailbox to read, search and send email with your approval

    • 8 tools
    • Remote
    • Freemium
    • Communication