sqlassistant

# SQL-Assistant SQL-Assistant is an MCP service built on the [MCP protocol](https://modelcontextprotocol.io/introduction). By exposing a series of methods for solving SQL problems to AI, users can issue commands to the AI to achieve automated problem-solving. The goal is to simplify operations for college students, allowing them to escape from the busy and often unproductive computer education in universities, spend less time completing tasks, and dedicate more time to learning truly practical skills. Corresponding website: [希冀](https://course.educg.net/), specifically for SQL assignments. ## Download Instructions ### Prerequisites - Go 1.24.2 - [Windows](https://go.dev/dl/go1.24.2.windows-amd64.msi) - [MacOS ARM64](https://go.dev/dl/go1.24.2.darwin-arm64.pkg) - [MacOS x64](https://go.dev/dl/go1.24.2.darwin-amd64.pkg) - [Linux](https://go.dev/dl/go1.24.2.linux-amd64.tar.gz) - VSCode + Cline plugin (or other platforms that can connect to MCP services, such as Claude Desktop, Gemini) - [VSCode](https://code.visualstudio.com/) - [Chrome](https://www.google.com/intl/en_hk/chrome/) ### Download ``` go install github.com/crazyfrankie/sqlassistant ``` Wait for the download to complete, and proceed to the next configuration step. ### Configuration Please ensure that you have prepared VSCode + Cline plugin. Go to the Cline interface, select the top right corner, and you will see the following interface.  Then select `Installed`  Next, choose `Configure MCP Servers`, fill in the configuration. For this project, a basic configuration can be as follows: ``` { "mcpServers": { "sqlassistant": { "command": "sqlassistant.exe", "autoApprove": [ "GetQuestion", "SetCode", "StartNum", "SubmitCode" ] } } } ``` If you are not on a Windows platform, remove the `.exe` suffix from `"command": "sqlassistant.exe"`. After completing the configuration, press `ctrl + s` to save the file for it to take effect. Next, configure the AI model. Go to the settings interface:  Select the large model you want to use and enter your personal API Key. Still on this interface, scroll to the bottom  Click `Relauch Browser with Debug Mode`, and check the `Use Remote browser connection` option. At this point, a new Chrome window will open. Open the database problem-solving website in this window and log in. Once logged in successfully, do not close this window during the subsequent process. ## Usage After completing the above configuration, go to the chat interface,  Send a prompt, such as (for reference only): ``` “I need to use sqlassistant to solve problems, first input the starting and ending question numbers, then loop through GetProblem, SetCode, SubmitCode until I receive an end message, and retry for any other failure reasons.” ```