SQL-Assistant

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.