MCPInstall
InstantDB logo

InstantDB

by christophersutton 1 stars christophersutton/instantdb-mcp

Provides a robust InstantDB server for executing database queries, retrieving results, and serving code examples across admin, CLI, and data modeling contexts.

READMEmain

instantdb-server MCP Server

An MCP server for interacting with InstantDB.

This server provides a read-only interface for querying InstantDB using a dynamically loaded schema and environment configuration. It includes tools to execute queries and retrieve query examples based on pre-defined patterns.

Features

Tools

  • get_examples
    Returns pre-defined example queries for various categories (e.g., "basic_read", "filtering", "associations").

  • queryDB
    Executes a specific query against InstantDB. Requires a query and a descriptive name parameter.

  • list_queries
    Retrieves the history of executed queries with details such as query ID, name, timestamp, and structure.

  • return_query
    Retrieves a specific query by its unique ID for later reference or implementation.

Schema and Environment Integration

  • Dynamic loading of the InstantDB schema from common file locations relative to a provided project directory (e.g., instant.schema.ts, src/instant.schema.ts, app/instant.schema.ts).
  • Environment variable configuration is loaded from the project’s .env file. Essential variables include:
    • INSTANT_APP_ID
    • INSTANT_APP_ADMIN_TOKEN

Pending Features

  • Dynamic detection of the InstantDB permissions file from common file locations.

Development

Install dependencies:

npm install

Build the server:

npm run build

For development with auto-rebuild:

npm run watch

Installation

To use the server with Claude Desktop, add the following configuration to your Claude Desktop settings:

On macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json

Example configuration:

{
  "mcpServers": {
    "instantdb-server": {
      "command": "node",
      "args": ["/path/to/instantdb-server/build/index.js"],
      "env": {
        "INSTANT_APP_ID": "your_app_id",
        "INSTANT_APP_ADMIN_TOKEN": "your_admin_token"
      },
      "disabled": false,
      "autoApprove": []
    }
  }
}

Debugging

For debugging MCP server communications, use the MCP Inspector:

npm run inspector

The Inspector will provide a URL to access tools for monitoring MCP server operations.

More Database MCP servers

Similar servers from the same category.

Provides direct access to Teradata database systems with specialized tools for executing queries, exploring database structures, monitoring performance, and analyzing data quality without leaving your conversation context.

database

Enables natural language management of Prisma Postgres databases, including creating instances, running schema migrations, and managing tables through the Prisma CLI

database

VideoDB

video-db

Bridges to VideoDB's video processing capabilities for searching, indexing, subtitling, and manipulating video content through specialized context resources.

databasesearch

JDBC Database Connector

openlinksoftware

Provides a bridge between relational databases and language models through JDBC connections, enabling SQL, SPARQL, and SPASQL queries with special optimizations for Virtuoso DBMS features like knowledge graph exploration.

database