ARC MCP Server

MCP Server

This directory contains the MCP server, which will host the AI agent and manage integrations with various data sources.

Prerequisites

Node.js >= 14
A Supabase project (for credential storage)
direnv (optional, for directory-specific environment variable loading)

Note: On startup (npm start or npm run dev), the server will automatically:
Create the AI & User Review/ folder
Scaffold the PROGRESS.md progress tracker
Bootstrap the database schema
See "Automated Database Setup" below.

Directory-specific environment loading (optional)
To automatically load your project-specific OPENAI_API_KEY (and other env vars) when you enter this directory, consider using direnv.
Copy .envrc.example to .envrc, fill in your OPENAI_API_KEY, then run direnv allow.

Folder Structure

Progress Review/
Directory for storing user-provided review artifacts (screenshots, logs, transcripts).
The CLI ensures this folder exists automatically on startup.
PROGRESS.md
Markdown file auto-generated to track project progress and next steps.
.envrc.example
Template for direnv configuration to auto-load project-specific environment variables.

Quickstart

The easiest way to bootstrap a new MCP Server project is via the create-mcp-server CLI:

# Scaffold a new project in one command (requires Node.js >=14)
npx create-mcp-server my-mcp-server
cd my-mcp-server
# The above will install dependencies, prompt for env vars, setup the database,
# and prepare the review folder.

npm start

Setup

Run the interactive initialization script to configure core and integration-specific environment variables and bootstrap your project (you'll be prompted to select which integrations to configure):
npm run init
Install dependencies:
npm install
Note: If you selected Google Custom Search integration, this will install the googleapis package required for the google_cse helper.
Start the server (creates review folder, applies migrations, and bootstraps database automatically):
npm start

Environment Variables

See .env.example for the full list.

Development

To start in watch mode (with nodemon):

npm run dev

Deployment to Vercel

This project can be deployed to Vercel. To do so:

Create a new project in your Vercel organization.
Set the following Environment Variables in the Vercel dashboard (under Project Settings → Environment Variables):
- SUPABASE_URL
- SUPABASE_SERVICE_ROLE_KEY (or SUPABASE_ANON_KEY)
- GOHIGHLEVEL_API_KEY
- STRIPE_SECRET_KEY
- QUICKBOOKS_CLIENT_ID
- QUICKBOOKS_CLIENT_SECRET
- AIRTABLE_API_KEY
- AIRTABLE_BASE_ID
- N8N_ENDPOINT
- N8N_API_KEY
- ANTHROPIC_API_KEY
- GOOGLE_CSE_API_KEY
- GOOGLE_CSE_ENGINE_ID
Connect your GitHub repository (using a personal access token if needed) and deploy.

MCP Server Development Guide

A comprehensive MCP Server Development Guide is available in the docs directory. It covers:

Core MCP concepts (tools, resources, prompts)
Implementation examples in various languages
Claude Desktop integration steps
Security and debugging considerations
Production deployment guidance

Agents ("Butler") Endpoint

Before using the agents endpoints, create an agents table in your Supabase database with the following columns:

Column	Type	Description
id	uuid	Primary key, autogenerated (default)
name	text	Name of the agent
description	text	Optional description of the agent
config	jsonb	Configuration data for the agent
created_at	timestamptz	Timestamp of creation, default now()

Endpoints

POST /agents
Create a new agent.
Request body:
{ "name": "butler", "description": "The initial AI butler agent", "config": { /* integration settings, credentials ref, etc. */ } }
Response: 201 with the created agent.
GET /agents
List all registered agents.
Response: 200 with an array of agents.

Database Setup

Automated Database Setup

Database/table migrations run automatically on server start via the prestart and predev hooks.

When you execute npm start or npm run dev, the required agents and orders tables will be created if they do not already exist.

Migrations: All SQL migrations are located in scripts/migrations. The first migration enables the raw_sql helper and required extensions; subsequent migrations create the agents and orders tables and add RLS policies. The db:setup script will automatically apply these migrations (in sorted order) on every server start.

Manual Database Setup

Before applying migrations or starting the server, ensure the raw_sql helper exists in your database. In your Supabase SQL editor, run:

create extension if not exists pgre_modules;
create or replace function raw_sql(sql text) returns jsonb language plpgsql as $$
declare result jsonb;
begin
  execute sql into result;
  return to_jsonb(result);
end;
$$;

Then run the following SQL to create the necessary tables if you prefer manual setup:

-- Table for agent definitions (the "butler")
create table if not exists agents (
  id uuid primary key default gen_random_uuid(),
  name text not null,
  description text,
  config jsonb,
  created_at timestamptz default now()
);

-- Table for agent orders
create table if not exists orders (
  id uuid primary key default gen_random_uuid(),
  agent_id uuid references agents(id) not null,
  payload jsonb not null,
  status text default 'pending',
  created_at timestamptz default now()
);

This server cannot be installed

security - not tested

license - not found

quality - not tested

A Node.js server that hosts AI agents and manages integrations with various data sources like Supabase, supporting automated database setup and deployment to Vercel.

Related MCP Servers

DeepClaude MCP Server
Way-To-AGI
-
security
F
license
-
quality
This server integrates DeepSeek and Claude AI models to provide enhanced AI responses, featuring a RESTful API, configurable parameters, and robust error handling.
Last updated -
13
TypeScript
EVM MCP Server
chulanpro5
-
security
A
license
-
quality
A comprehensive server that enables AI agents to interact with multiple EVM-compatible blockchain networks through a unified interface, supporting ENS resolution, token operations, and smart contract interactions.
Last updated -
230
TypeScript
MIT License
MySQL MCP Server
LeonMelamud
-
security
F
license
-
quality
A powerful server that enables AI agents to interact with MySQL databases, execute SQL queries, and manage database content through a simple interface.
Last updated -
25
4
JavaScript
Hedera MCP Server
HGraphPunks
-
security
F
license
-
quality
A production-ready Node.js server that enables decentralized communication between AI agents on the Hedera network, implementing the Model-Context-Protocol architecture with support for multiple Hedera Consensus Service standards.
Last updated -
TypeScript

View all related MCP servers