get-table-schemaLABSCO SUMMARY
A backend the coding agent can change, with the dangerous parts fenced off.
Most database servers stop at queries. This one also creates buckets, ships edge functions and deploys, which is the difference between an assistant that answers questions about your backend and one that builds it. Raw SQL stays admin-key-only and behind the same strict-mode endpoint the REST API uses.
What it is
The MCP server for InsForge, an open-source backend bundling Postgres, auth, storage, realtime, functions and a model gateway, giving an AI coding assistant direct access to your project.
What you get
- Read the table schema, run raw SQL in strict mode, and bulk insert or upsert
- Create, list and delete storage buckets
- Create, read, update and delete Deno edge functions
- Create and start a deployment, then read the container logs back
- Pull the docs, generate an anon key, and index backend metadata so the assistant knows the shape of the project
Requirements
An InsForge project and an AI coding assistant such as Cursor, Claude Code or GitHub Copilot. Write and admin actions need your admin API key, and raw SQL runs through the same strict-mode endpoint as the REST API, where system tables and the auth users table are blocked.
Setup effort
One command plus a key — npx @insforge/install --client claude-code --env API_KEY=<YOUR_API_KEY> --env API_BASE_URL=http://localhost:7130
USE CASES
01
Building a feature end to end from the editor
The assistant reads the schema, writes the query, adds the edge function and deploys, without you switching to a dashboard.
02
Loading a dataset into a fresh table
Bulk upsert takes the rows in one call rather than a loop of inserts.
03
Debugging a deployment that failed
Read the container logs over the same connection that started the deployment.
04
Getting the assistant oriented in the project
The docs tool pulls the InsForge instructions so the agent stops guessing at the API shape.
16 tools
Listed in project docs. Your client may show a different list.
run-raw-sqlbulk-upsertcreate-bucketlist-bucketsdelete-bucketcreate-functionget-functionupdate-functiondelete-functioncreate-deploymentstart-deploymentget-container-logsfetch-docsget-anon-keyget-backend-metadataBEFORE YOU INSTALL
What to know first
Tools you get
16 tools named in the project's documentation.
Requires
- npx on PATH
- API_KEY in your environment
INSTALLATION
Connect your client
Server setup
npx
TERMINAL
npx @insforge/install --client claude-code --env API_KEY=<YOUR_API_KEY> --env API_BASE_URL=http://localhost:7130<YOUR_API_KEY> is your InsForge project's API key; the URL after it is your InsForge backend URL (for example https://your-app.us-east.insforge.app). Both are in your project's Settings, under the Connect tab. Keep localhost:7130 only for an InsForge instance running on this machine. Most client tabs below connect to InsForge's hosted endpoint instead, where you sign in through the browser and paste no key; the Trae tab asks for the same key and URL as this command.
Hosted endpoint
ENDPOINT URL
https://mcp.insforge.dev/mcpAdd this hosted endpoint to your MCP client, then sign in.
MCP Clients
Claude Code
CLAUDE CODE · JSON
{
"mcpServers": {
"insforge": {
"type": "http",
"url": "https://mcp.insforge.dev/mcp"
}
}
}Gemini CLI
GEMINI CLI · JSON
{
"mcpServers": {
"insforge": {
"httpUrl": "https://mcp.insforge.dev/mcp"
}
}
}Cursor
CURSOR · JSON
{
"mcpServers": {
"insforge": {
"url": "https://mcp.insforge.dev/mcp"
}
}
}Windsurf
WINDSURF · JSON
{
"mcpServers": {
"insforge": {
"command": "npx",
"args": [
"-y",
"mcp-remote",
"https://mcp.insforge.dev/mcp"
]
}
}
}Cline
In Cline, add a remote server (Cline's guide: https://docs.cline.bot/mcp/connecting-to-a-remote-server) with Server Name insforge, Server URL https://mcp.insforge.dev/mcp and Transport Type Streamable HTTP
Cline then shows an error asking you to authenticate — click Authenticate and sign in to your InsForge account in the browser
Roo Code
ROO CODE · TERMINAL
npx -y @smithery/cli mcp add devel/insforge --client roocodeRun it in a terminal. It is InsForge's own install line for Roo Code on the hosted endpoint, like the other tabs here.
Trae
In Trae open Settings → MCP, click Add → Add from Marketplace, search "InsForge" and add it
Set API_KEY and API_BASE_URL — both are in your InsForge project's Settings, under the Connect tab
GitHub Copilot
GITHUB COPILOT · JSON
{
"servers": {
"insforge": {
"type": "http",
"url": "https://mcp.insforge.dev/mcp"
}
}
}Antigravity
ANTIGRAVITY · JSON
{
"mcpServers": {
"insforge": {
"serverUrl": "https://mcp.insforge.dev/mcp"
}
}
}OpenCode
OPENCODE · JSON
{
"mcp": {
"insforge": {
"type": "remote",
"url": "https://mcp.insforge.dev/mcp",
"enabled": true
}
}
}
