Skip to content
MCP server

Secure Schema MCP

Read-only MCP server for exposing database schema metadata without row data.

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
1.0.1
Listing updated
5 days ago

About Secure Schema MCP

Secure Schema MCP is an open-source MCP server. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add secure-schema --env DATABASE_URL='<DATABASE_URL>' -- uvx mcp-secure-schema

Add to claude_desktop_config.json

{
  "mcpServers": {
    "secure-schema": {
      "command": "uvx",
      "args": [
        "mcp-secure-schema"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "secure-schema": {
      "command": "uvx",
      "args": [
        "mcp-secure-schema"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "secure-schema": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "mcp-secure-schema"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "secure-schema": {
      "command": "uvx",
      "args": [
        "mcp-secure-schema"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "secure-schema": {
      "command": "uvx",
      "args": [
        "mcp-secure-schema"
      ],
      "env": {
        "DATABASE_URL": "<DATABASE_URL>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • DATABASE_URLSQLAlchemy database URL used for schema inspection.Required
  • DATABASE_SCHEMAOptional default schema or catalog namespace. In production it is locked and tool arguments cannot override it.
  • ALLOWED_TABLESOptional comma-separated table/view allowlist. When set, only listed tables and views are visible.
  • SECURE_SCHEMA_ENVSet to production to require ALLOWED_TABLES during startup.
  • FASTMCP_CHECK_FOR_UPDATESSet to off to disable FastMCP startup update checks.
  • FASTMCP_SHOW_SERVER_BANNERSet to false to suppress the FastMCP startup banner.

Pricing

Open source

Secure Schema MCP FAQ

Is Secure Schema MCP free?

Yes. Secure Schema MCP is open source, so you can use and self-host it for free.

How do I add Secure Schema MCP to Claude Code?

Run this command in your terminal: claude mcp add secure-schema --env DATABASE_URL='<DATABASE_URL>' -- uvx mcp-secure-schema

Where this comes from

  • Description: from the official MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers