Skip to main content
Glama
deenesjakoruzh
illusionist-2

SQL and File MCP

by illusionist-2
OverviewSchemaRelated ServersScoreDiscussions
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 installed

A
license - permissive license
-
quality - not tested
D
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

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

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
    27
    4
    MIT

  • sqlserver-mcp-colossal

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

View all related MCP servers

Related MCP Connectors

  • mcp-aichat

    MCP server for AI dialogue using various LLM models via AceDataCloud

  • mcp

    GibsonAI MCP server: manage your databases with natural language

  • mcp

    MCP server providing access to the Scorecard API to evaluate and optimize LLM systems.

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/illusionist-2/mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server