# Caspio MCP server

> Query, insert, update and delete records in your Caspio tables and views using natural language from any MCP client.

- Listing: https://mcp.tc/i/caspio
- Connect: use the server's own URL `https://mcp.caspio.com/mcp` (OAuth sign-in at the server); clients connect to it directly. The listing link is a page, not an MCP endpoint.
- Type: remote (Streamable HTTP)
- Auth: OAuth sign-in
- Category: [Databases & Backend](https://mcp.tc/c/databases)
- Vendor: Caspio
- Homepage: <https://www.caspio.com/ai/mcp-server/>

## About

Connects AI assistants such as ChatGPT and Claude to the structured data in a Caspio account. You can query, insert, update and delete records in tables and views, for example to look up open cases, add a lead or change a project status.

The server runs as a hosted streamable HTTP endpoint at mcp.caspio.com. Every connection authenticates through a Caspio API profile that you create, scope and can revoke. A new profile has no permissions until you grant Read, Insert, Update or Delete per table and view.

## What it can do

- Query records in Caspio tables and views
- Insert new records
- Update existing records
- Delete records
- Grant Read, Insert, Update and Delete permissions per table and view
- Revoke API profile access at any time

## Example prompts

- "Show me last quarter's open support cases from Caspio."
- "Add a new lead named Jane Smith to my Contacts table."
- "Update the status of project Atlas to Complete."
- "List the records in my Inventory view with stock below 10."

## Install

### Claude Code

1. Run this in a terminal, in your project folder:

```bash
claude mcp add --transport http caspio https://mcp.caspio.com/mcp
```

2. Start Claude Code, type `/mcp`, pick **caspio** and choose **Authenticate**. A browser window opens for the Caspio sign-in.

Add `--scope user` to make it available in every project, not just this one.

### Claude Desktop

1. Open **Customize → Connectors**, click **+ Add**, then **Add custom connector**.

2. Name it **Caspio** and paste this URL:

```url
https://mcp.caspio.com/mcp
```

3. Click **Add**, then **Connect**, and sign in when Caspio asks.

Claude Desktop’s JSON config file only starts local servers. Remote servers go through Connectors, and connectors you add on claude.ai show up here too.

### claude.ai

1. Open the connector form on claude.ai. This button fills in the name and URL for you:

[Add to claude.ai](<https://claude.ai/customize/connectors?modal=add-custom-connector&connectorName=Caspio&connectorUrl=https%3A%2F%2Fmcp.caspio.com%2Fmcp>) (opens connector settings)

2. Check that the URL reads `https://mcp.caspio.com/mcp` and click **Add**.

3. Click **Connect** and sign in when Caspio asks.

Free plans allow one custom connector. On Team and Enterprise plans an owner adds it under **Organization settings → Connectors**.

### ChatGPT

1. On chatgpt.com, go to **Plugins**, select **+**, then **Add custom MCP server**.

2. Enter a name for the server.

3. Under **Connection**, paste `https://mcp.caspio.com/mcp` as the server URL, then for authentication choose **OAuth**. ChatGPT sends you to Caspio to sign in.

4. Check **I understand and want to continue**, then select **Create as a plugin**.

Whether you can add a custom MCP server depends on your ChatGPT plan and your workspace permissions (in Business workspaces, admins and owners can).

### Cursor

[Add to Cursor](<https://cursor.com/install-mcp?name=caspio&config=eyJ1cmwiOiJodHRwczovL21jcC5jYXNwaW8uY29tL21jcCJ9>) (opens Cursor)

Or add it by hand to `~/.cursor/mcp.json` (all projects) or `.cursor/mcp.json` (this project):

`mcp.json`:

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

Cursor shows **Needs authentication** next to the server. Click the button beside it to sign in.

### VS Code

[Install in VS Code](<https://vscode.dev/redirect/mcp/install?name=caspio&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.caspio.com%2Fmcp%22%7D>) (opens VS Code)

Or from a terminal:

```bash
code --add-mcp '{"name":"caspio","type":"http","url":"https://mcp.caspio.com/mcp"}'
```

Or commit it to the repo in `.vscode/mcp.json`:

`.vscode/mcp.json`:

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

VS Code asks you to sign in the first time the server starts.

### Devin Desktop

1. Add it to `~/.config/devin/mcp_config.json` (macOS and Linux) or `%APPDATA%\devin\mcp_config.json` (Windows):

`mcp_config.json`:

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

2. Refresh the MCP server list in Cascade and sign in when asked.

Devin Desktop is the new name for Windsurf. It reads `serverUrl` (or `url`) for remote servers.

### Codex

```bash
codex mcp add caspio --url https://mcp.caspio.com/mcp
codex mcp login caspio
```

Or edit `~/.codex/config.toml` directly:

`config.toml`:

```toml
[mcp_servers.caspio]
url = "https://mcp.caspio.com/mcp"
```

### Gemini CLI

```bash
gemini mcp add --transport http caspio https://mcp.caspio.com/mcp
```

Then, inside Gemini CLI, run `/mcp auth caspio` to sign in.

This adds it to the current project. Add `-s user` to use it everywhere.

### Any client

Most clients accept this shape. Some name the URL field differently: `serverUrl` in Devin Desktop, `httpUrl` in Gemini CLI’s settings file.

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

Zed puts servers under `context_servers` in its settings. Cline needs `"type": "streamableHttp"`, or it assumes SSE.

Client only starts local servers? Bridge it with `npx -y mcp-remote https://mcp.caspio.com/mcp`.

## Details

- Server version: 1.2.2
- Last checked: 2026-11-17 (reachable, asks for credentials)
- Listed: 2026-10-08
- Updated: 2026-10-08

---
Source: https://mcp.tc/i/caspio (mcp.tc is an independent directory, not affiliated with this server's publisher). Corrections: https://mcp.tc/report
