@FocusSearch
基本情報
A NL2SQL plugin based on FocusSearch keyword parsing, offering greater accuracy, higher speed, and more reliability!
ツール一覧はまだありません
この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。
ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。
Focus_mcp_sql is a Model Context Protocol (MCP) server that enables AI assistants to convert natural language into SQL statements. It employs a transparent two-step generation process (keywords first, then SQL) to reduce LLM hallucinations and build trust in the generated SQL results.
Clone the repository, build the server with Gradle (requires JDK 23+ and Gradle 8.12+), then add the server to your MCP settings file with the java -jar command. After configuration, use the gptText2sqlStart tool to initialize the model with table schema (and a Datafocus bearer token), then use gptText2sqlChat to convert natural language queries into SQL.
It uses a two-step approach: first generates keywords from the natural language query, then maps those keywords deterministically to SQL. This keyword verification step makes the process transparent and controllable, lowering hallucination risk.
You need JDK 23 or higher, Gradle 8.12 or higher, and a registered Datafocus account to obtain a bearer token for authentication.
The table schema and bearer token are sent to the server as parameters in the `gptText2sqlStart` tool. The actual database is not accessed directly; only the metadata provided by the user is used.
The server communicates over stdio via the MCP protocol, as configured in the MCP settings file with a `java -jar` command.
The server relies on the Datafocus API for token authentication and keyword generation. It is designed for structured table schemas and does not handle unstructured data or complex joins without explicit relation definitions.
Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.
A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.
Local MCP server for DuckDB and MotherDuck
A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
コメント