MCP.so
登录

SQL Assistant MCP Server

@crazyfrankie

基本信息

分类

数据库

传输方式

stdio

作者

crazyfrankie

关于 SQL Assistant MCP Server

A SQL automation do questions MCP Server

SQL Assistant MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块,请前往代码仓库查看安装说明。

代码仓库

SQL Assistant MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is SQL-Assistant?

SQL-Assistant is an MCP (Model Context Protocol) server that automates solving SQL problems from the XiJi (course.educg.net) platform. It exposes methods for handling SQL questions to AI agents, allowing users to complete tedious coursework assignments with minimal effort.

How to use SQL-Assistant?

Install Go 1.24.2, then run go install github.com/crazyfrankie/sqlassistant. Configure the MCP server in VS Code Cline by adding a JSON entry with the command sqlassistant (or sqlassistant.exe on Windows) and auto-approved tools: GetQuestion, SetCode, StartNum, SubmitCode. Set up an AI model with your API key, launch Chrome in debug mode, log into the XiJi SQL assignment page, and send prompts to the AI to execute the automated workflow.

Key features of SQL-Assistant

  • Automates SQL problem‑solving on the XiJi platform.
  • Exposes MCP tools: GetQuestion, SetCode, StartNum, SubmitCode.
  • Works with any MCP‑compatible host (VS Code Cline, Claude Desktop, Gemini).
  • Requires Chrome remote debugging to interact with the target website.
  • Supports customisable AI model selection and API key configuration.

Use cases of SQL-Assistant

  • Automatically fetching SQL problems and submitting solutions.
  • Repeating the question‑solve‑submit cycle for a range of exercise numbers.
  • Reducing manual effort for routine database coursework assignments.

常见问题

1

Which website does SQL-Assistant support?

SQL-Assistant is designed specifically for SQL assignments on the XiJi platform (course.educg.net).

2

What dependencies are required?

Go 1.24.2, Visual Studio Code with the Cline extension (or another MCP host), Chrome browser, and an AI model API key.

3

How do I configure the MCP tools?

In the Cline MCP servers configuration, set the command to `sqlassistant` (or `sqlassistant.exe` on Windows) and list `GetQuestion`, `SetCode`, `StartNum`, `SubmitCode` under `autoApprove`.

4

Do I need to keep the browser open?

Yes, the Chrome window opened with remote debugging (where you logged into XiJi) must remain open throughout the session.

5

What transport or authentication does the server use?

The server runs locally as a subprocess launched by the MCP host; no explicit authentication is mentioned.

评论

数据库 分类下的更多 MCP 服务器