FOCUS DATA MCP Server
Enables AI assistants to query data from DataFocus using natural language.
FOCUS DATA MCP Server [中文]
A Model Context Protocol (MCP) server enables artificial intelligence assistants to directly query data results. Users can obtain data results from DataFocus using natural language.
Features
- Register on DataFocus to open an application space, and import (directly connect to) the data tables to be analyzed.
- Select Datafocus data table initialization dialogue
- Natural language data acquisition results
Prerequisites
- jdk 23 or higher. Download jdk
- gradle 8.12 or higher. Download gradle
- register Datafocus to obtain bearer token:
- Register an account in Datafocus
- Create an application
- Enter the application
- Admin -> Interface authentication -> Bearer Token -> New Bearer Token
Installation
- Clone this repository:
git clone https://github.com/FocusSearch/focus_mcp_data.git
cd focus_mcp_data
- Build the server:
gradle clean
gradle bootJar
The jar path: build/libs/focus_mcp_data.jar
MCP Configuration
Add the server to your MCP settings file (usually located
at ~/AppData/Roaming/Code/User/globalStorage/saoudrizwan.claude-dev/settings/cline_mcp_settings.json
):
{
"mcpServers": {
"focus_mcp_data": {
"command": "java",
"args": [
"-jar",
"path/to/focus_mcp_data/focus_mcp_data.jar"
],
"autoApprove": [
"tableList",
"gptText2DataInit",
"gptText2DataData"
]
}
}
}
Available Tools
1. tableList
Get table list in datafocus.
Parameters:
name
(optional): table name to filterbearer
(required): bearer token
Example:
{
"name": "test",
"bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU="
}
2. gptText2DataInit
Initialize dialogue.
Parameters:
names
(required): selected table namesbearer
(required): bearer tokenlanguage
(optional): language ['english','chinese']
Example:
{
"names": [
"test1",
"test2"
],
"bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU="
}
3. gptText2DataData
Query data results.
Parameters:
chatId
(required): chat idinput
(required): Natural languagebearer
(required): bearer token
Example:
{
"chatId": "03975af5de4b4562938a985403f206d4",
"input": "max(age)",
"bearer": "ZTllYzAzZjM2YzA3NDA0ZGE3ZjguNDJhNDjNGU4NzkyYjY1OTY0YzUxYWU5NmU="
}
Response Format
All tools return responses in the following format:
{
"errCode": 0,
"exception": "",
"msgParams": null,
"promptMsg": null,
"success": true,
"data": {
}
}
Visual Studio Code Cline Sample
- vsCode install cline plugin
- mcp server config
- use
- get table list
- Initialize dialogue
- query: what is the sum salary
- get table list
Contact:
Related Servers
GraphRAG
Query a hybrid graph (Neo4j) and vector (Qdrant) database for powerful semantic and graph-based document retrieval.
AskTable
Interact with AskTable SaaS or local deployments to query data sources using natural language.
Postgres MCP
A remote MCP server for Postgres, deployable on Cloudflare Workers without authentication.
KnowledgeGraph MCP Server
Enables persistent knowledge storage for Claude using a knowledge graph with multiple database backends like PostgreSQL and SQLite.
Grist
Integrate with the Grist API to manage relational spreadsheets and data. Requires a Grist API key.
Tesouro Direto MCP Server
Provides natural language access to Brazilian treasury bond data from the Tesouro Direto API, allowing users to query market data and bond details.
Snow Leopard BigQuery MCP
Interact with Google BigQuery databases using natural language queries and schema exploration.
SchemaCrawler
Connect to any relational database, and be able to get valid SQL, and ask questions like what does a certain column prefix mean.
Odoo Accounting MCP Server
Integrates with Odoo Accounting via XML-RPC, allowing AI tools to query and analyze account journal entries for auditing purposes.
Avro MCP Server by CData
A read-only MCP server for Avro data sources, powered by the CData JDBC Driver.