SQL and File MCP

Name: SQL and File MCP
Availability: InStock

An MCP (Model Context Protocol) server that gives LLM clients access to a SQL Server database and the local filesystem.

Setup

{
  "mcpServers": {
    "mssql-server": {
      "command": "node",
      "args": ["/absolute/path/to/server.js"]
    }
  }
}

Tool	Description
`query`	Run a `SELECT` query against the configured SQL Server database. Write queries are blocked.

Tool	Description
`read_file`	Read a text file and return its contents.
`write_file`	Write (or append) text to a file. Creates the file if it doesn't exist.
`delete_file`	Delete a file.
`copy_file`	Copy a file from source to destination.
`move_file`	Move or rename a file or directory.
`file_info`	Get metadata for a file or directory (size, created, modified, accessed).
`list_directory`	List the contents of a directory. Supports recursive listing.
`create_directory`	Create a directory and any missing parent directories.
`delete_directory`	Delete a directory. Pass `recursive: true` to delete non-empty directories.

Tool	Description
`read_image`	Read a local image file and return it as base64. Supports `png`, `jpg`, `gif`, `webp`.
`compare_images`	Load two images side-by-side for visual comparison. Each source can be a local file path or an `http/https` URL.

Variable	Description
`DB_USER`	SQL Server username
`DB_PASSWORD`	SQL Server password
`DB_SERVER`	Hostname or IP of the SQL Server
`DB_PORT`	Port (default: `1433`)
`DB_NAME`	Database name