Skip to main content
Glama

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.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • 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
      -
    • 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
      6
      MIT
    • 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.
      4 npm
      MIT