Advertise
MCP.so
Sign In

SQL Assistant MCP Server

@crazyfrankie

Repository

Basic information

Category

Databases

Transports

stdio

Author

crazyfrankie

About SQL Assistant MCP Server

A SQL automation do questions MCP Server

SQL Assistant MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

SQL Assistant MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Frequently asked questions

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.

Comments

More Databases MCP servers

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K
Advertise