How do I use SQL and File MCP?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@SQL and File MCP query the users table for all active users" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

SQL and File MCP

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

Setup

Install dependencies:
```
npm install
```
Copy .env and fill in your database credentials:
```
cp .env.example .env
```
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

Register the server in your MCP client config (e.g. Claude Desktop claude_desktop_config.json):

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

Tools

Database

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

File system

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.

Images

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.

This server cannot be installed

A

license - permissive license

-

quality - not tested

C

maintenance

How are these scores calculated?

Resources

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

SQL and File MCP

SQL and File MCP

Setup

Tools

Database

File system

Images

Resources

Looking for Admin?

Latest Blog Posts

MCP directory API

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