InstantDB
An MCP server for interacting with InstantDB, a realtime database.
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.
Related Servers
MariaDB / MySQL
Provides access to MariaDB and MySQL databases for querying and data manipulation.
PubChem-MCP
Access PubChem's database for chemical compounds, substances, and bioassays.
DBeaver MCP Server
Integrates with DBeaver to provide AI assistants access to over 200 database types using existing connections.
MySQL Server
A server for accessing and managing MySQL databases.
Airtable
Interact with Airtable's API to manage bases, tables, and records.
Neo4j
Neo4j graph database server (schema + read/write-cypher) and separate graph database backed memory
BigQuery
Inspect database schemas and execute queries on Google BigQuery.
BioMCP
Connects AI assistants to authoritative biomedical data sources like PubMed and ClinicalTrials.gov, enabling natural language queries.
PostgreSQL MCP Server by CData
A read-only MCP server for PostgreSQL, enabling LLMs to query live data from PostgreSQL databases.
Kollect MCP Server (Standalone)
An MCP server for querying data from the Kollect tool's API endpoints, such as /api/data, /api/snapshots, and /api/costs.