MCP.so
ログイン

SQL-Assistant

@crazyfrankie

リポジトリ

SQL-Assistant について

A SQL automation do questions MCP Server

基本情報

カテゴリ

データベース

ランタイム

go

トランスポート

stdio

公開者

crazyfrankie

設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

ツール

ツールは検出されませんでした

ツールは 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.

FAQ from SQL-Assistant

Which website does SQL-Assistant support?

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

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.

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.

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.

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.

コメント

「データベース」の他のコンテンツ

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Elasticsearch MCP Server

elastic

685

MCP Server for MySQL based on NodeJS

benborla

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.

1.9K