1. Conduid
  2. Data
  3. Sqlassistant
MCP server · Data

Sqlassistant

by · github.com/crazyfrankie/sqlassistant

A SQL automation do questions MCP Server

Unclaimed last commit a year ago data
InstallView source
41Fair

Scored yesterday · breakdown

About Sqlassistant

Sqlassistant is an MCP server published by crazyfrankie in the Data category: a SQL automation do questions MCP Server.

The repository has 3 stars and 0 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.

Install

From source
git clone https://github.com/crazyfrankie/sqlassistant

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Ask AI

✦

Ask AI about Sqlassistant

Powered by Claude · Grounded in docs

I know everything about Sqlassistant. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

Static checks derived from the repository yesterday. Heuristics on the source, not an audit.

  • ✓README presentThe repository ships documentation.
  • !License declaredNo license file. Legally you have no right to use it in a product.
  • !Tests presentNo tests found. Behaviour changes may go unnoticed between versions.
  • ✓Dependencies pinnedA lockfile pins dependency versions.
  • ✓No dynamic code executionSource scan found no eval, dynamic Function, or shell execution.
  • !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.

Releases

v2.0.0release v2.0.0 · 27 Apr 2025
v1.0.0release v1.0.0 · 27 Apr 2025

README

SQL-Assistant

SQL-Assistant 是一个基于 MCP协议 构建的 MCP 服务. 通过将做 SQL 题目的一系列方法暴露给 AI, 再由用户对AI发出指令进行驱动，达到自动化做题的效果。 旨在简化大学生的操作, 让大学生从繁忙且无用的大学计算机教育中脱身, 花更少的时间完成任务，把时间留着学习真正的实用的技术。

对应的网站: 希冀, 且必须是其中的 SQL 作业.

下载方式

前置条件

下载

go install github.com/crazyfrankie/sqlassistant

等待下载，下载成功后进行下一步配置.

配置

请确认已经准备好 vscode + cline 插件. 来到 Cline 的界面, 选择右上角, 会看到如下界面. img.png

然后选择下方 Installed img.png

再选择 Configure MCP Servers, 填写配置, 对于本项目, 一个基础的配置可采用如下方式:

{
  "mcpServers": {
    "sqlassistant": {
      "command": "sqlassistant.exe",
      "autoApprove": [
        "GetQuestion",
        "SetCode",
        "StartNum",
        "SubmitCode"
      ]
    }
  }
}

如不是 Windows 平台, 去掉 "command": "sqlassistant.exe" 中的exe后缀

配置完毕后, ctrl + s 保存该文件即可生效.

下一步, 配置 AI 模型. 来到设置界面: img.png

选择想要使用的大模型, 并填入个人的 API Key

仍然是该界面, 滑到最下方 img.png

点击 Relauch Browser with Debug Mode, 并将上方 Use Remote browser connection 勾选.

此时会打开一个新的 Chrome 界面, 在该界面上打开数据库做题网站, 并登录, 登录成功后即可, 后续过程中不能关闭该界面。

使用

上述配置完成之后，来到聊天界面, img.png

发送 prompt, 如下（仅参考）:

“我需要使用sqlassistant进行做题, 先输入起止题号，再循环执行 GetProblem、SetCode、SubmitCode，直到收到结束信息为止，其他失败原因都进行重试。”

README fetched from the repository yesterday. The original is authoritative.

Questions

About Sqlassistant

How do I install Sqlassistant?

No package has been published for this server, so install it from source: clone the repository and follow its README.

Is Sqlassistant safe to use with an AI agent?

Its trust score is 41 out of 100 (fair). It passes 3 of the 6 static security checks run so far; the failures are listed above. It has no ConduID identity yet, so agent calls to it are not receipted.

Is Sqlassistant still maintained?

The last commit was a year ago. That's long enough that you should check whether the maintainer is responding to issues before depending on it.