Skip to main content
Glama
deenesjakoruzh
illusionist-2

SQL and File MCP

by illusionist-2
OverviewSchemaSourceRelated ServersDiscussionsAdmin
JavaScript
Local

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

  1. Install dependencies:

    npm install

  2. 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

  3. 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"]
    }
  }
}

Related MCP server: SQL Server MCP

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 deployed

One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources

Related MCP Connectors

Related MCP Servers

  • MCP SQL Server

    miguel1603
    F
    license
    A
    quality
    D
    maintenance
    An MCP server that connects LLMs to SQL databases for development assistance, enabling query execution, schema exploration, and data manipulation while providing safety controls against destructive operations.
    5
    -

  • SQL Server MCP

    az-coder-123
    A
    license
    B
    quality
    D
    maintenance
    An MCP server that connects AI assistants to Microsoft SQL Server databases, enabling schema exploration and read-only queries safely.
    49
    9 npm
    4
    MIT

  • sqlserver-mcp-colossal

    JavianDev
    A
    license
    Not graded
    quality
    D
    maintenance
    A comprehensive MCP server for SQL Server database operations, enabling CRUD operations, schema exploration, and stored procedure execution through natural language.
    9 npm
    MIT