x=hub

your toolset

    build deployment
    sign in

    schemacrawler-ai

    mcpother
    io.github.schemacrawler/schemacrawler-ai · vv17.16.0-1
    deploy just this

    Enables natural language schema queries — explore tables, keys, procedures, and get SQL help fast

    run it

    on your own machines, one way per deploy method
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    #!/usr/bin/env bash
# schemacrawler-ai (io.github.schemacrawler/schemacrawler-ai), recipe docker (generated).
# Generated by Hub for toolset "my-agent"; started by mcp-my-agent-schemacrawler-ai.service.
set -euo pipefail
export HOST=127.0.0.1 PORT=8101
exec docker run --rm --name mcp-my-agent-schemacrawler-ai -p 127.0.0.1:${PORT}:8000 -e SCHCRWLR_MCP_SERVER_TRANSPORT -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD -e SCHCRWLR_JDBC_URL -e SCHCRWLR_SERVER -e SCHCRWLR_HOST -e SCHCRWLR_PORT -e SCHCRWLR_DATABASE -e SCHCRWLR_DATABASE_ALIAS -e SCHCRWLR_DATABASE_DESCRIPTION -e SCHCRWLR_INFO_LEVEL -e SCHCRWLR_LOG_LEVEL -e SCHCRWLR_EXCLUDE_TOOLS schemacrawler/schemacrawler-ai:17.16.0-1

[Unit]
Description=MCP server schemacrawler-ai (toolset my-agent), generated by Hub
After=network-online.target docker.service
Wants=network-online.target

[Service]
Type=simple
User=mcp
Group=mcp
SupplementaryGroups=docker
EnvironmentFile=/etc/mcp/my-agent.env
Environment=HOME=/var/lib/mcp/schemacrawler-ai
WorkingDirectory=/var/lib/mcp/schemacrawler-ai
ExecStart=/opt/mcp/my-agent/bin/schemacrawler-ai.sh
Restart=on-failure
RestartSec=5
NoNewPrivileges=true
ProtectSystem=strict
ProtectHome=true
PrivateTmp=true
ReadWritePaths=/var/lib/mcp/schemacrawler-ai

[Install]
WantedBy=multi-user.target
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    docker run --rm -p 127.0.0.1:8101:8000 -e SCHCRWLR_MCP_SERVER_TRANSPORT -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD -e SCHCRWLR_JDBC_URL -e SCHCRWLR_SERVER -e SCHCRWLR_HOST -e SCHCRWLR_PORT -e SCHCRWLR_DATABASE -e SCHCRWLR_DATABASE_ALIAS -e SCHCRWLR_DATABASE_DESCRIPTION -e SCHCRWLR_INFO_LEVEL -e SCHCRWLR_LOG_LEVEL -e SCHCRWLR_EXCLUDE_TOOLS schemacrawler/schemacrawler-ai:17.16.0-1
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    # Generated by Hub for toolset "my-agent" (2026-10-18T23:17:52+00:00).
# Each package server runs behind a stdio->HTTP bridge and listens on localhost only.
#   cp .env.example .env    # fill the ${VAR}s
#   docker compose up -d && bash smoke.sh
# Remote servers are not here: clients reach them directly (see clients/).
name: mcp-my-agent
services:
  schemacrawler-ai:
    image: schemacrawler/schemacrawler-ai:17.16.0-1
    ports:
    - 127.0.0.1:8101:8000
    restart: unless-stopped
    x-note: 'CHANGE_ME: check the image''s README for its transport and port; this assumes streamable
      HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command
      instead.'
    environment:
      SCHCRWLR_MCP_SERVER_TRANSPORT: ${SCHCRWLR_MCP_SERVER_TRANSPORT}
      SCHCRWLR_DATABASE_USER: ${SCHCRWLR_DATABASE_USER}
      SCHCRWLR_DATABASE_PASSWORD: ${SCHCRWLR_DATABASE_PASSWORD}
      SCHCRWLR_JDBC_URL: ${SCHCRWLR_JDBC_URL}
      SCHCRWLR_SERVER: ${SCHCRWLR_SERVER}
      SCHCRWLR_HOST: ${SCHCRWLR_HOST}
      SCHCRWLR_PORT: ${SCHCRWLR_PORT}
      SCHCRWLR_DATABASE: ${SCHCRWLR_DATABASE}
      SCHCRWLR_DATABASE_ALIAS: ${SCHCRWLR_DATABASE_ALIAS}
      SCHCRWLR_DATABASE_DESCRIPTION: ${SCHCRWLR_DATABASE_DESCRIPTION}
      SCHCRWLR_INFO_LEVEL: ${SCHCRWLR_INFO_LEVEL}
      SCHCRWLR_LOG_LEVEL: ${SCHCRWLR_LOG_LEVEL}
      SCHCRWLR_EXCLUDE_TOOLS: ${SCHCRWLR_EXCLUDE_TOOLS}
volumes:
  npm-cache: {}
  uv-cache: {}
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    # Generated by Hub for toolset "my-agent" (2026-10-18T23:17:52+00:00).
#   kubectl create namespace mcp
#   kubectl -n mcp create secret generic mcp-credentials --from-env-file=.env
#   kubectl apply -f kubernetes.yaml
# Services are cluster-internal: <name>.mcp.svc.cluster.local:8000/mcp. Put an ingress
# with auth in front before exposing any of them.
apiVersion: v1
kind: Namespace
metadata:
  name: mcp
---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: schemacrawler-ai
  namespace: mcp
  labels: &id001
    app: schemacrawler-ai
spec:
  replicas: 1
  selector:
    matchLabels: *id001
  template:
    metadata:
      labels: *id001
    spec:
      containers:
      - name: schemacrawler-ai
        image: schemacrawler/schemacrawler-ai:17.16.0-1
        ports:
        - containerPort: 8000
          name: http
        env:
        - name: SCHCRWLR_MCP_SERVER_TRANSPORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_MCP_SERVER_TRANSPORT
        - name: SCHCRWLR_DATABASE_USER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_DATABASE_USER
        - name: SCHCRWLR_DATABASE_PASSWORD
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_DATABASE_PASSWORD
        - name: SCHCRWLR_JDBC_URL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_JDBC_URL
        - name: SCHCRWLR_SERVER
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_SERVER
        - name: SCHCRWLR_HOST
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_HOST
        - name: SCHCRWLR_PORT
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_PORT
        - name: SCHCRWLR_DATABASE
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_DATABASE
        - name: SCHCRWLR_DATABASE_ALIAS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_DATABASE_ALIAS
        - name: SCHCRWLR_DATABASE_DESCRIPTION
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_DATABASE_DESCRIPTION
        - name: SCHCRWLR_INFO_LEVEL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_INFO_LEVEL
        - name: SCHCRWLR_LOG_LEVEL
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_LOG_LEVEL
        - name: SCHCRWLR_EXCLUDE_TOOLS
          valueFrom:
            secretKeyRef:
              name: mcp-credentials
              key: SCHCRWLR_EXCLUDE_TOOLS
---
apiVersion: v1
kind: Service
metadata:
  name: schemacrawler-ai
  namespace: mcp
spec:
  selector:
    app: schemacrawler-ai
  ports:
  - port: 8000
    targetPort: http
    name: http
    generated from the record, not tested yet
    CHANGE_ME: check the image's README for its transport and port; this assumes streamable HTTP at :8000/mcp. If it speaks stdio only, use it from clients/mcp.json as a `docker run -i` command instead.
    # Generated by Hub for toolset "my-agent" (2026-10-18T23:17:52+00:00).
# Credentials come from the Secret 'mcp-credentials' (kubectl create secret generic ... --from-env-file=.env).
# Each server under `servers` is one Deployment + Service; the keys after it configure
# upstream charts a worker verified.
servers:
  schemacrawler-ai:
    enabled: true
    replicas: 1
    port: 8000
    path: /mcp
    container:
      name: schemacrawler-ai
      image: schemacrawler/schemacrawler-ai:17.16.0-1
      ports:
      - containerPort: 8000
        name: http
      env:
      - name: SCHCRWLR_MCP_SERVER_TRANSPORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_MCP_SERVER_TRANSPORT
      - name: SCHCRWLR_DATABASE_USER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_DATABASE_USER
      - name: SCHCRWLR_DATABASE_PASSWORD
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_DATABASE_PASSWORD
      - name: SCHCRWLR_JDBC_URL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_JDBC_URL
      - name: SCHCRWLR_SERVER
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_SERVER
      - name: SCHCRWLR_HOST
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_HOST
      - name: SCHCRWLR_PORT
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_PORT
      - name: SCHCRWLR_DATABASE
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_DATABASE
      - name: SCHCRWLR_DATABASE_ALIAS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_DATABASE_ALIAS
      - name: SCHCRWLR_DATABASE_DESCRIPTION
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_DATABASE_DESCRIPTION
      - name: SCHCRWLR_INFO_LEVEL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_INFO_LEVEL
      - name: SCHCRWLR_LOG_LEVEL
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_LOG_LEVEL
      - name: SCHCRWLR_EXCLUDE_TOOLS
        valueFrom:
          secretKeyRef:
            name: mcp-credentials
            key: SCHCRWLR_EXCLUDE_TOOLS

# helm install my-agent helm/my-agent -n mcp

    in the cloud

    one click: the provider's deploy form opens filled in, in your own account
    koyeb
    deploy to koyeb

    The form opens with CHANGE_ME for each value you supply: SCHCRWLR_MCP_SERVER_TRANSPORT, SCHCRWLR_DATABASE_USER, SCHCRWLR_DATABASE_PASSWORD, SCHCRWLR_JDBC_URL, SCHCRWLR_SERVER, SCHCRWLR_HOST, SCHCRWLR_PORT, SCHCRWLR_DATABASE, SCHCRWLR_DATABASE_ALIAS, SCHCRWLR_DATABASE_DESCRIPTION, SCHCRWLR_INFO_LEVEL, SCHCRWLR_LOG_LEVEL, SCHCRWLR_EXCLUDE_TOOLS. Fill them in before you deploy.

    Clients connect to the service's https://…koyeb.app address plus /mcp.

    azure
    deploy to azuretemplate

    A Container Apps environment with one app per server, each with HTTPS ingress and one replica. The portal asks for each value you supply as a secure parameter; the deployment's outputs list the endpoints.

    connect to it

    copy what your client needs
    docker run -i --rm -e SCHCRWLR_MCP_SERVER_TRANSPORT -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD -e SCHCRWLR_JDBC_URL -e SCHCRWLR_SERVER -e SCHCRWLR_HOST -e SCHCRWLR_PORT -e SCHCRWLR_DATABASE -e SCHCRWLR_DATABASE_ALIAS -e SCHCRWLR_DATABASE_DESCRIPTION -e SCHCRWLR_INFO_LEVEL -e SCHCRWLR_LOG_LEVEL -e SCHCRWLR_EXCLUDE_TOOLS schemacrawler/schemacrawler-ai:17.16.0-1
    {
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_MCP_SERVER_TRANSPORT",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "-e",
        "SCHCRWLR_JDBC_URL",
        "-e",
        "SCHCRWLR_SERVER",
        "-e",
        "SCHCRWLR_HOST",
        "-e",
        "SCHCRWLR_PORT",
        "-e",
        "SCHCRWLR_DATABASE",
        "-e",
        "SCHCRWLR_DATABASE_ALIAS",
        "-e",
        "SCHCRWLR_DATABASE_DESCRIPTION",
        "-e",
        "SCHCRWLR_INFO_LEVEL",
        "-e",
        "SCHCRWLR_LOG_LEVEL",
        "-e",
        "SCHCRWLR_EXCLUDE_TOOLS",
        "schemacrawler/schemacrawler-ai:17.16.0-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "${SCHCRWLR_MCP_SERVER_TRANSPORT}",
        "SCHCRWLR_DATABASE_USER": "${SCHCRWLR_DATABASE_USER}",
        "SCHCRWLR_DATABASE_PASSWORD": "${SCHCRWLR_DATABASE_PASSWORD}",
        "SCHCRWLR_JDBC_URL": "${SCHCRWLR_JDBC_URL}",
        "SCHCRWLR_SERVER": "${SCHCRWLR_SERVER}",
        "SCHCRWLR_HOST": "${SCHCRWLR_HOST}",
        "SCHCRWLR_PORT": "${SCHCRWLR_PORT}",
        "SCHCRWLR_DATABASE": "${SCHCRWLR_DATABASE}",
        "SCHCRWLR_DATABASE_ALIAS": "${SCHCRWLR_DATABASE_ALIAS}",
        "SCHCRWLR_DATABASE_DESCRIPTION": "${SCHCRWLR_DATABASE_DESCRIPTION}",
        "SCHCRWLR_INFO_LEVEL": "${SCHCRWLR_INFO_LEVEL}",
        "SCHCRWLR_LOG_LEVEL": "${SCHCRWLR_LOG_LEVEL}",
        "SCHCRWLR_EXCLUDE_TOOLS": "${SCHCRWLR_EXCLUDE_TOOLS}"
      }
    }
  }
}
    #!/usr/bin/env bash
# Registers every server with Claude Code (run once; `claude mcp list` to check).
set -euo pipefail
set -a; [ -f .env ] && source .env; set +a
claude mcp add schemacrawler-ai -e "SCHCRWLR_MCP_SERVER_TRANSPORT=${SCHCRWLR_MCP_SERVER_TRANSPORT}" -e "SCHCRWLR_DATABASE_USER=${SCHCRWLR_DATABASE_USER}" -e "SCHCRWLR_DATABASE_PASSWORD=${SCHCRWLR_DATABASE_PASSWORD}" -e "SCHCRWLR_JDBC_URL=${SCHCRWLR_JDBC_URL}" -e "SCHCRWLR_SERVER=${SCHCRWLR_SERVER}" -e "SCHCRWLR_HOST=${SCHCRWLR_HOST}" -e "SCHCRWLR_PORT=${SCHCRWLR_PORT}" -e "SCHCRWLR_DATABASE=${SCHCRWLR_DATABASE}" -e "SCHCRWLR_DATABASE_ALIAS=${SCHCRWLR_DATABASE_ALIAS}" -e "SCHCRWLR_DATABASE_DESCRIPTION=${SCHCRWLR_DATABASE_DESCRIPTION}" -e "SCHCRWLR_INFO_LEVEL=${SCHCRWLR_INFO_LEVEL}" -e "SCHCRWLR_LOG_LEVEL=${SCHCRWLR_LOG_LEVEL}" -e "SCHCRWLR_EXCLUDE_TOOLS=${SCHCRWLR_EXCLUDE_TOOLS}" -- docker run -i --rm -e SCHCRWLR_MCP_SERVER_TRANSPORT -e SCHCRWLR_DATABASE_USER -e SCHCRWLR_DATABASE_PASSWORD -e SCHCRWLR_JDBC_URL -e SCHCRWLR_SERVER -e SCHCRWLR_HOST -e SCHCRWLR_PORT -e SCHCRWLR_DATABASE -e SCHCRWLR_DATABASE_ALIAS -e SCHCRWLR_DATABASE_DESCRIPTION -e SCHCRWLR_INFO_LEVEL -e SCHCRWLR_LOG_LEVEL -e SCHCRWLR_EXCLUDE_TOOLS schemacrawler/schemacrawler-ai:17.16.0-1

    {
  "mcpServers": {
    "schemacrawler-ai": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_MCP_SERVER_TRANSPORT",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "-e",
        "SCHCRWLR_JDBC_URL",
        "-e",
        "SCHCRWLR_SERVER",
        "-e",
        "SCHCRWLR_HOST",
        "-e",
        "SCHCRWLR_PORT",
        "-e",
        "SCHCRWLR_DATABASE",
        "-e",
        "SCHCRWLR_DATABASE_ALIAS",
        "-e",
        "SCHCRWLR_DATABASE_DESCRIPTION",
        "-e",
        "SCHCRWLR_INFO_LEVEL",
        "-e",
        "SCHCRWLR_LOG_LEVEL",
        "-e",
        "SCHCRWLR_EXCLUDE_TOOLS",
        "schemacrawler/schemacrawler-ai:17.16.0-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "${SCHCRWLR_MCP_SERVER_TRANSPORT}",
        "SCHCRWLR_DATABASE_USER": "${SCHCRWLR_DATABASE_USER}",
        "SCHCRWLR_DATABASE_PASSWORD": "${SCHCRWLR_DATABASE_PASSWORD}",
        "SCHCRWLR_JDBC_URL": "${SCHCRWLR_JDBC_URL}",
        "SCHCRWLR_SERVER": "${SCHCRWLR_SERVER}",
        "SCHCRWLR_HOST": "${SCHCRWLR_HOST}",
        "SCHCRWLR_PORT": "${SCHCRWLR_PORT}",
        "SCHCRWLR_DATABASE": "${SCHCRWLR_DATABASE}",
        "SCHCRWLR_DATABASE_ALIAS": "${SCHCRWLR_DATABASE_ALIAS}",
        "SCHCRWLR_DATABASE_DESCRIPTION": "${SCHCRWLR_DATABASE_DESCRIPTION}",
        "SCHCRWLR_INFO_LEVEL": "${SCHCRWLR_INFO_LEVEL}",
        "SCHCRWLR_LOG_LEVEL": "${SCHCRWLR_LOG_LEVEL}",
        "SCHCRWLR_EXCLUDE_TOOLS": "${SCHCRWLR_EXCLUDE_TOOLS}"
      }
    }
  }
}
    {
  "servers": {
    "schemacrawler-ai": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "SCHCRWLR_MCP_SERVER_TRANSPORT",
        "-e",
        "SCHCRWLR_DATABASE_USER",
        "-e",
        "SCHCRWLR_DATABASE_PASSWORD",
        "-e",
        "SCHCRWLR_JDBC_URL",
        "-e",
        "SCHCRWLR_SERVER",
        "-e",
        "SCHCRWLR_HOST",
        "-e",
        "SCHCRWLR_PORT",
        "-e",
        "SCHCRWLR_DATABASE",
        "-e",
        "SCHCRWLR_DATABASE_ALIAS",
        "-e",
        "SCHCRWLR_DATABASE_DESCRIPTION",
        "-e",
        "SCHCRWLR_INFO_LEVEL",
        "-e",
        "SCHCRWLR_LOG_LEVEL",
        "-e",
        "SCHCRWLR_EXCLUDE_TOOLS",
        "schemacrawler/schemacrawler-ai:17.16.0-1"
      ],
      "env": {
        "SCHCRWLR_MCP_SERVER_TRANSPORT": "${SCHCRWLR_MCP_SERVER_TRANSPORT}",
        "SCHCRWLR_DATABASE_USER": "${SCHCRWLR_DATABASE_USER}",
        "SCHCRWLR_DATABASE_PASSWORD": "${SCHCRWLR_DATABASE_PASSWORD}",
        "SCHCRWLR_JDBC_URL": "${SCHCRWLR_JDBC_URL}",
        "SCHCRWLR_SERVER": "${SCHCRWLR_SERVER}",
        "SCHCRWLR_HOST": "${SCHCRWLR_HOST}",
        "SCHCRWLR_PORT": "${SCHCRWLR_PORT}",
        "SCHCRWLR_DATABASE": "${SCHCRWLR_DATABASE}",
        "SCHCRWLR_DATABASE_ALIAS": "${SCHCRWLR_DATABASE_ALIAS}",
        "SCHCRWLR_DATABASE_DESCRIPTION": "${SCHCRWLR_DATABASE_DESCRIPTION}",
        "SCHCRWLR_INFO_LEVEL": "${SCHCRWLR_INFO_LEVEL}",
        "SCHCRWLR_LOG_LEVEL": "${SCHCRWLR_LOG_LEVEL}",
        "SCHCRWLR_EXCLUDE_TOOLS": "${SCHCRWLR_EXCLUDE_TOOLS}"
      }
    }
  }
}
    name: my-agent
target: local
servers:
- hub: io.github.schemacrawler/schemacrawler-ai
    • not probed yet: tools unpinned, ingest lists them

    tools

    Not probed yetThe tools appear once the hub or its worker has listed this entry. Running it still works: your client lists them on first start.