@b1bridge/mcp-server

MCP server for SAP Business One on SQL Server

Connects Claude Desktop (or any MCP-compatible client) to your SAP Business One database. Query your ERP data with natural language.

What it provides

10 Tools for Claude

| Tool | Description | |------|-------------| | query | Execute read-only SQL queries (write operations blocked) | | list_tables | List all tables with row counts, filterable by name | | describe_table | Full column schema with types, PKs, and constraints | | list_schemas | List database schemas | | get_company_info | SAP B1 company details from OADM | | list_b1_modules | SAP B1 tables organized by module (Financials, Sales, etc.) | | sample_data | Preview first N rows of any table | | search_columns | Find columns by name across all 2,400+ tables | | get_table_relationships | Foreign key relationships for any table | | count_rows | Quick row counts for multiple tables |

3 Reference Resources

| Resource | Description | |----------|-------------| | Financial Reporting Guide | P&L construction via GroupMask, AR/AP aging patterns | | Common Join Patterns | Standard header→lines, BP, item, and GL joins | | Naming Conventions | SAP B1 table prefixes, column names, and patterns |

Safety Features

• Read-only by default — INSERT, UPDATE, DELETE, DROP, ALTER, EXEC all blocked
• Row limits — Maximum 500 rows per query, 50 for previews
• Table name sanitization — Basic SQL injection prevention
• Connection pooling — Efficient connection management

Installation

npm install -g @b1bridge/mcp-server

Configuration

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "b1bridge": {
      "command": "npx",
      "args": ["-y", "@b1bridge/mcp-server"],
      "env": {
        "MSSQL_HOST": "your-server",
        "MSSQL_INSTANCE": "MSSQLSERVER",
        "MSSQL_PORT": "1433",
        "MSSQL_DATABASE": "your-sap-b1-database",
        "MSSQL_USER": "sa",
        "MSSQL_PASSWORD": "your-password",
        "MSSQL_ENCRYPT": "false",
        "MSSQL_TRUST_SERVER_CERTIFICATE": "true"
      }
    }
  }
}

Windows Authentication

Omit MSSQL_USER and MSSQL_PASSWORD to use Windows (NTLM) authentication.

Environment Variables

| Variable | Required | Default | Description | |----------|----------|---------|-------------| | MSSQL_HOST | Yes | localhost | SQL Server hostname | | MSSQL_INSTANCE | No | — | Named instance (e.g., MSSQLSERVER) | | MSSQL_PORT | No | 1433 | TCP port | | MSSQL_DATABASE | Yes | master | SAP B1 database name | | MSSQL_USER | No* | — | SQL auth username | | MSSQL_PASSWORD | No* | — | SQL auth password | | MSSQL_ENCRYPT | No | false | Encrypt connection | | MSSQL_TRUST_SERVER_CERTIFICATE | No | true | Trust self-signed certs |

*Required for SQL Authentication. Omit for Windows Authentication.

Usage in Claude

Once configured, restart Claude Desktop. You can then ask:

• "Show me my top 10 customers by revenue this quarter"
• "Generate a P&L for January through March"
• "What's my current inventory value by warehouse?"
• "List all overdue invoices over $5,000"
• "Describe the OINV table"
• "What tables are related to purchasing?"

License

Proprietary — KIUBO S.A. © 2026

Part of the B1 Bridge product suite. Visit b1bridge.com.