greptimedb-mcp-server
A Model Context Protocol (MCP) server implementation for GreptimeDB.
This server provides AI assistants with a secure and structured way to explore and analyze databases. It enables them to list tables, read data, and execute SQL queries through a controlled interface, ensuring responsible database access.
Capabilities
list_resourcesto list tables
read_resourceto read table data
list_toolsto list tools
call_toolto execute an SQL
list_promptsto list prompts
get_promptto get the prompt by name
Installation
Configuration
Set the following environment variables:
Or via command-line args:
--hostthe database host
--portthe database port
--userthe database username
--passwordthe database password
--databasethe database name
Usage
Claude Desktop Integration
Configure the MCP server in Claude Desktop's configuration file:
MacOS
Location:
~/Library/Application Support/Claude/claude_desktop_config.jsonWindows
Location:
%APPDATA%/Claude/claude_desktop_config.jsonLicense
MIT License - see LICENSE.md file for details.
Contribute
Prerequisites
- Python with
uvpackage manager
- GreptimeDB installation
- MCP server dependencies
Development
Use MCP Inspector for debugging:
Acknowledgement
This library's implementation was inspired by the following two repositories and incorporates their code, for which we express our gratitude
Thanks!
greptimedb-mcp-server
A Model Context Protocol (MCP) server implementation for GreptimeDB.
This server provides AI assistants with a secure and structured way to explore and analyze databases. It enables them to list tables, read data, and execute SQL queries through a controlled interface, ensuring responsible database access.
Capabilities
list_resourcesto list tables
read_resourceto read table data
list_toolsto list tools
call_toolto execute an SQL
list_promptsto list prompts
get_promptto get the prompt by name
Installation
Configuration
Set the following environment variables:
Or via command-line args:
--hostthe database host
--portthe database port
--userthe database username
--passwordthe database password
--databasethe database name
Usage
Claude Desktop Integration
Configure the MCP server in Claude Desktop's configuration file:
MacOS
Location:
~/Library/Application Support/Claude/claude_desktop_config.jsonWindows
Location:
%APPDATA%/Claude/claude_desktop_config.jsonLicense
MIT License - see LICENSE.md file for details.
Contribute
Prerequisites
- Python with
uvpackage manager
- GreptimeDB installation
- MCP server dependencies
Development
Use MCP Inspector for debugging:
Acknowledgement
This library's implementation was inspired by the following two repositories and incorporates their code, for which we express our gratitude
Thanks!