@happyrobot-ai/mcp-twin
v0.1.1
Published
HappyRobot Twin Database MCP Server - Explore schemas, run queries, and manage tables via Claude Code or any MCP client
Readme
@happyrobot-ai/mcp-twin
Deprecated: This stdio MCP server is deprecated. Use the remote Streamable HTTP server instead — no Node.js or API keys required, authentication is handled via OAuth.
Claude Code:
claude mcp add --transport http happyrobot-twin https://mcp.platform.happyrobot.ai/twin/mcpThen run
/mcpand click Authenticate.Claude Desktop: Download the installer from docs.happyrobot.ai/claude-desktop.
Full documentation: docs.happyrobot.ai/developer-tools/mcp-twin
A Model Context Protocol (MCP) server for managing your HappyRobot Twin database. Explore schemas, run queries, and manage tables from Claude Desktop, Claude Code, or any MCP-compatible client.
Quick Start
Claude Code
claude mcp add -s user happyrobot-twin -- npx @happyrobot-ai/mcp-twinOr with the API key pre-configured:
claude mcp add -s user happyrobot-twin -e HAPPYROBOT_API_KEY=sk_live_xxx -- npx @happyrobot-ai/mcp-twinClaude Desktop
Add to your claude_desktop_config.json:
{
"mcpServers": {
"happyrobot-twin": {
"command": "npx",
"args": ["@happyrobot-ai/mcp-twin"],
"env": {
"HAPPYROBOT_API_KEY": "sk_live_your_key_here"
}
}
}
}.mcp.json (project-level)
{
"mcpServers": {
"happyrobot-twin": {
"command": "npx",
"args": ["@happyrobot-ai/mcp-twin"],
"env": {
"HAPPYROBOT_API_KEY": "sk_live_your_key_here"
}
}
}
}Configuration
| Variable | Description | Default |
| -------------------- | ----------------------------------------- | ------------------ |
| HAPPYROBOT_API_KEY | Your API key (sk_live_* or sk_test_*) | (none, required) |
If the API key is not set via environment variable, use the setup tool at runtime to provide it.
Available Tools
| Tool | Description |
| ---------------- | --------------------------------------------------------------- |
| setup | Configure your API key at runtime |
| get_schema | List all tables and views with columns, types, and primary keys |
| get_table_data | Fetch rows from a table with pagination |
| create_table | Create a new table with typed columns |
| execute_sql | Run arbitrary SQL (SELECT, INSERT, UPDATE, DELETE, DDL) |
| insert_row | Insert a single row into a table |
| update_row | Update rows matching a WHERE clause |
| delete_rows | Delete rows from a table by primary key |
| drop_table | Drop a table permanently |
Limits
- SQL queries have a 5-second timeout
- SELECT results are capped at 500 rows / 1 MB
Development
# Install dependencies
npm install
# Run in development mode
HAPPYROBOT_API_KEY=sk_test_xxx npm run dev
# Build for production
npm run buildLicense
MIT
