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.

コメント

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