Datatape
Getting Started

Quickstart

Go from zero to a working MCP endpoint in 5 minutes.

Quickstart

This guide walks you through connecting a database, creating a tool, and exposing it to Claude — in under 5 minutes.

Prerequisites

  • A Datatape account (sign up free)
  • A database you want to query (PostgreSQL, MySQL, Snowflake, BigQuery, or Google Sheets)
  • An AI client that supports MCP (Claude Desktop, Claude Code, Cursor, or ChatGPT)

Step 1: Create an organization

After signing in, you'll be prompted to create an organization. This is your workspace — all sources, tools, and team members live here.

Step 2: Connect a source

Go to Sources and click Add source.

  1. Choose your database type (e.g., PostgreSQL)
  2. Enter your connection details:
    • Host, port, database name
    • Username and password (read-only credentials recommended)
  3. Click Test connection to verify
  4. Click Save
Add source form on the Sources page with PostgreSQL selected

Your credentials are encrypted at rest with Fernet (AES-128-CBC + HMAC). They are never returned in API responses, never logged, and never accessible to AI agents.

Step 3: Create a tool

Go to Tools and click Create tool.

  1. Give it a name and description (AI agents use the description to decide when to call it)
  2. Select the source you just connected
  3. Write a SQL template:
SELECT customer_name, total_spent
FROM customers
WHERE region = {{ region }}
ORDER BY total_spent DESC
LIMIT {{ limit }}
  1. Add parameters:
    • region — type: string, required: true
    • limit — type: number, required: false, default: 10
  2. Click Test to run the query with sample values
  3. Click Save
Create Tool step 2 — Name, Description, Timeout, Parameters, and SQL Template editor

All SQL templates are validated as read-only by SQLGlot. INSERT, UPDATE, DELETE, and DROP statements are rejected at the platform level.

Step 4: Create an agent

Go to Agents and click Create agent.

  1. Give it a name and optional description (e.g., "Customer Data Bot")
  2. Assign tools directly or via a toolset
  3. Click Create

Your agent is created with an embedded API key. The full key is shown once — copy it and store it securely.

Agent detail page right after creation, with API key revealed once

The API key is only displayed once at creation time. If you lose it, you can rotate the key from the agent detail page to generate a new one.

Step 5: Connect Claude

Your organization's MCP endpoint is:

https://your-org-id.mcp.datatape.ai/mcp

Claude Desktop

Add this to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json):

{
  "mcpServers": {
    "datatape": {
      "url": "https://your-org-id.mcp.datatape.ai/mcp"
    }
  }
}

Claude Code

claude mcp add datatape https://your-org-id.mcp.datatape.ai/mcp

Cursor

Go to Settings > MCP Servers > Add Server and paste your endpoint URL.

Claude Desktop calling a Datatape tool

Interactive clients like Claude Desktop use OAuth to authenticate — you'll sign in via your browser. For programmatic access, use an agent API key in the Authorization: Bearer dt_xxx header.

What's next?

On this page