Provides tools and resources for coding agents to interact with the Gel database, including automatic project configuration for query builders and ORMs.
This MCP server provides tools and resources that help coding agents use the Gel database.
execute_query
: run a query against the Gel instance configured in the current project. Supports arguments and globals.try_query
: run a query in a transaction that gets rolled back in the end, preventing actual data modification.list_examples
and fetch_example
: access code examples for advanced workflows such as configuring the AI extension.list_rules
and fetch_rule
: in case you forgot to configure Gel rules in your text editor, the agent can access them like this, too.If at any point you get lost, refer to this repository to see an example config layout for your editor.
.cursor/mcp.json
:{
"mcpServers": {
"gel": {
"command": "uvx",
"args": [
"--refresh",
"--python",
"3.13",
"--directory",
".",
"--from",
"git+https://github.com/geldata/gel-mcp.git",
"gel-mcp"
]
}
}
}
View: Open MCP Settings
and toggle Gel in there.Add the following to .mcp.json
:
{
"mcpServers": {
"gel": {
"command": "uvx",
"args": [
"--refresh",
"--python",
"3.13",
"--directory",
".",
"--from",
"git+https://github.com/geldata/gel-mcp.git",
"gel-mcp"
]
}
}
}
Add the following to .vscode/mcp.json
:
{
"servers": {
"gel": {
"type": "stdio",
"command": "uvx",
"args": [
"--refresh",
"--python",
"3.13",
"--directory",
".",
"--from",
"git+https://github.com/geldata/gel-mcp.git",
"gel-mcp"
]
}
}
}
Follow Windsurf Cascade's documentation to open global mcp_config.json
via the clicky interface.
Add the following:
{
"mcpServers": {
"gel": {
"command": "uvx",
"args": [
"--refresh",
"--python",
"3.13",
"--directory",
".",
"--from",
"git+https://github.com/geldata/gel-mcp.git",
"gel-mcp"
]
}
}
}
Add the following to .zed/settings.json
:
{
"context_servers": {
"gel": {
"source": "custom",
"command": {
"path": "uvx",
"args": [
"--refresh",
"--python",
"3.13",
"--directory",
".",
"--from",
"git+https://github.com/geldata/gel-mcp.git",
"gel-mcp"
],
"env": {}
}
}
}
}
Clone the repository and create the virtual environment:
uv sync
Open the server in the MCP Inspector:
mcp dev src/gel_mcp/server.py
Access Socrata Open Data APIs from government data portals.
Access financial statements, including income, balance sheets, and cash flow, for companies listed on the Securities Exchange of Thailand (SET).
An AI-powered server that generates PyAirbyte pipeline code and instructions using OpenAI and connector documentation.
Access MySQL databases to inspect schemas and execute SQL queries via a NodeJS-based server.
Connect to any relational database, and be able to get valid SQL, and ask questions like what does a certain column prefix mean.
Search and query patient Electronic Health Record (EHR) data using SMART on FHIR.
Query Vietnam stock intraday data using the SSI FastConnect API.
MCP server for libSQL databases with comprehensive security and management tools. Supports file, local HTTP, and remote Turso databases with connection pooling, transaction support, and 6 specialized database tools.
MCP Server for OceanBase database and its tools
Access Mina blockchain data, including events, actions, and network state, through the Mina Archive Node API.