open-index/open-npm huggingface dataset:
npm package: @iflow-mcp/connorbritain-mssql-mcp-server
Description: Model Context Protocol (MCP) server for Microsoft SQL Server - enterprise-ready schema discovery, profiling, and safe data operations
Author: Connor England
Latest version: 0.2.2

# MSSQL MCP Server

[![License: MIT](https://img.shields.io/badge/License-MIT-yellow.svg)](https://opensource.org/licenses/MIT)

**Enterprise-grade Model Context Protocol server for Microsoft SQL Server.**

Production-ready MCP server with 20 tools for schema discovery, data operations, profiling, and administration. Full governance controls for enterprise environments.

## Package Tiers

| Package | Tools | Use Case |
|---------|-------|----------|
| [@connorbritain/mssql-mcp-reader](https://www.npmjs.com/package/@connorbritain/mssql-mcp-reader) | 14 read-only | Analysts, auditors |
| [@connorbritain/mssql-mcp-writer](https://www.npmjs.com/package/@connorbritain/mssql-mcp-writer) | 17 (reader + data ops) | Data engineers |
| **@connorbritain/mssql-mcp-server** (this) | 20 (all tools) | DBAs, full admin |

## Tools

| Category | Tools |
|----------|-------|
| **Discovery** | `search_schema`, `describe_table`, `list_table`, `list_databases`, `list_environments` |
| **Profiling** | `profile_table`, `inspect_relationships`, `inspect_dependencies`, `explain_query` |
| **Data** | `read_data`, `insert_data`, `update_data`, `delete_data` |
| **DDL** | `create_table`, `create_index`, `drop_table` |
| **Scripts** | `list_scripts`, `run_script` |
| **Operations** | `test_connection`, `validate_environment_config` |

## Install

```bash
npm install -g @connorbritain/mssql-mcp-server@latest
```

## MCP Client Config

```json
{
  "mcpServers": {
    "mssql": {
      "command": "npx",
      "args": ["@connorbritain/mssql-mcp-server@latest"],
      "env": {
        "SERVER_NAME": "127.0.0.1",
        "DATABASE_NAME": "mydb",
        "SQL_AUTH_MODE": "sql",
        "SQL_USERNAME": "sa",
        "SQL_PASSWORD": "YourPassword123"
      }
    }
  }
}
```

## Configuration

| Variable | Required | Notes |
|----------|----------|-------|
| `SERVER_NAME` | Yes | SQL Server hostname/IP |
| `DATABASE_NAME` | Yes | Target database |
| `SQL_AUTH_MODE` | | `sql`, `windows`, or `aad` (default: `aad`) |
| `SQL_USERNAME` / `SQL_PASSWORD` | | Required for `sql`/`windows` modes |
| `READONLY` | | `true` disables write tools |
| `ENVIRONMENTS_CONFIG_PATH` | | Multi-environment JSON config |
| `SCRIPTS_PATH` | | Named SQL scripts directory |

## Features

- **Multi-environment support** - Named environments with per-environment policies
- **Governance controls** - `allowedTools`, `deniedTools`, `allowedSchemas`, `deniedSchemas`
- **Audit logging** - JSON Lines with session IDs and auto-redaction
- **Secret management** - `${secret:NAME}` placeholders
- **Safe mutations** - Preview/confirm for UPDATE and DELETE

## Documentation

**Full docs:** [github.com/ConnorBritain/mssql-mcp-server](https://github.com/ConnorBritain/mssql-mcp-server#readme)
npm package: @iflow-mcp/connordburge-lunchmoney-mcp-v2
Description: MCP server for Lunch Money, powered by the v2 TypeScript client
Author: ConnorDBurge
Latest version: 1.0.0

# lunchmoney-mcp-v2

A Model Context Protocol (MCP) server for [Lunch Money](https://lunchmoney.app) personal finance management, powered by the [`@lunch-money/lunch-money-js-v2`](https://github.com/lunch-money/lunch-money-js-v2) TypeScript client.

## Overview

This MCP server exposes Lunch Money's v2 API as tools for AI assistants (Claude Desktop, GitHub Copilot, VS Code, etc.). Ask your AI to manage transactions, check budgets, organize categories, and more — all through natural language.

## Setup

### Prerequisites

- Node.js >= 18
- A [Lunch Money API token](https://my.lunchmoney.app/developers)

### Install

```bash
pnpm install
pnpm build
```

### Configure

Set your API token as an environment variable:

```bash
export LUNCHMONEY_API_TOKEN=your_token_here
```

### Usage with Claude Desktop

Add to your Claude Desktop config (`~/Library/Application Support/Claude/claude_desktop_config.json`):

```json
{
  "mcpServers": {
    "lunchmoney": {
      "command": "node",
      "args": ["/path/to/lunchmoney-mcp-v2/build/index.js"],
      "env": {
        "LUNCHMONEY_API_TOKEN": "your_token_here"
      }
    }
  }
}
```

### Usage with GitHub Copilot CLI

Add to your Copilot CLI MCP config:

```json
{
  "mcpServers": {
    "lunchmoney": {
      "command": "node",
      "args": ["/path/to/lunchmoney-mcp-v2/build/index.js"],
      "env": {
        "LUNCHMONEY_API_TOKEN": "your_token_here"
      }
    }
  }
}
```

## Tools (40 total)

| Resource | Tools | Description |
|----------|-------|-------------|
| **User** | 1 | Get current user info |
| **Categories** | 5 | Full CRUD for spending categories |
| **Transactions** | 14 | CRUD, bulk ops, split/group, attachments |
| **Manual Accounts** | 5 | Full CRUD for manually-tracked accounts |
| **Plaid Accounts** | 3 | List, get, and trigger Plaid sync |
| **Tags** | 5 | Full CRUD for tags |
| **Recurring Items** | 2 | List and get recurring expenses |
| **Summary** | 1 | Budget summary |

## License

MIT