Koskamo

cds-db-nlquery-mcp

An MCP server for natural language queries against SAP CAP db-layer entities. It auto-discovers the schema from cds.model, generates real SQL JOINs, and returns rows. It supports Bring Your Own LLM (Anthropic, OpenAI, etc.) and targets the db/ layer with read-only SELECT capabilities.

Package and access

Local package with source-attributed installation metadata. Koskamo does not execute packages during review.

cds-db-nlquery-mcp logo, by shahidlaCommunity listingLocal stdioSource reviewed; not executedPublished by shahidla
You need:A CAP project with @sap/cds >= 7An MCP client (Claude Code, Claude Desktop, or any MCP-compatible host)An API key for an LLM provider
Vendor documentation

What you can do with it

  • Ask questions about your database in plain English
  • Auto-discover schema from cds.model
  • Generate real SQL JOINs using CDS
  • Return rows as vertical field/value lists

Source and maintenance

Community listingRegistry 0.7.3MIT
mcp-registry: io.github.shahidla/cds-db-nlquery-mcp@0.7.3Source repository
Last repository push
Maintenance checked

Packages and installation

Source-provided package data. Koskamo has not executed or live-probed this package.

@shahid.la/cds-db-nlquery-mcp 0.7.3

npm
@shahid.la/cds-db-nlquery-mcp package definition
{
  "version": "0.7.3",
  "transport": "stdio",
  "identifier": "@shahid.la/cds-db-nlquery-mcp",
  "registryType": "npm",
  "environmentVariables": [
    {
      "name": "ANTHROPIC_API_KEY",
      "format": "string",
      "description": "Anthropic API key (used if ANTHROPIC_API_KEY is set and OPENAI_API_KEY is not)"
    },
    {
      "name": "OPENAI_API_KEY",
      "format": "string",
      "description": "OpenAI (or OpenAI-compatible) API key"
    },
    {
      "name": "MCP_ALLOWED_ENTITIES",
      "format": "string",
      "description": "Comma-separated entity allowlist, enforced on JOINs too"
    },
    {
      "name": "MCP_BLOCKED_COLUMNS",
      "format": "string",
      "description": "Comma-separated column blocklist, stripped before the query is built"
    }
  ]
}

Tools

Reported by the attributed source; not independently observed by Koskamo.

No tool definitions available.

Maintenance history

Public check and source-refresh events. Editorial and ownership records remain private.

  • · repository · passed · metadata changed · updated
  • · backfill · recorded · Pre-expansion baseline; unobserved rich metadata remains unknown

Connect from your client

Each snippet configures the same source-provided package; replace placeholders before use.

This server is operated by the named third party. Listing and endpoint checks are not an endorsement or a security audit. Review the operator's permissions, terms, and data handling before connecting. How listings are checked and corrected.

Cursor

Merge this local stdio configuration, replace every placeholder environment value, and restart Cursor. Koskamo has not executed this package.
Cursor configuration
{
  "mcpServers": {
    "cds-db-nlquery-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@shahid.la/cds-db-nlquery-mcp@0.7.3"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "MCP_ALLOWED_ENTITIES": "<YOUR_MCP_ALLOWED_ENTITIES>",
        "MCP_BLOCKED_COLUMNS": "<YOUR_MCP_BLOCKED_COLUMNS>"
      }
    }
  }
}

Cline

Merge this local stdio configuration, replace every placeholder environment value, and restart Cline. Koskamo has not executed this package.
Cline configuration
{
  "mcpServers": {
    "cds-db-nlquery-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@shahid.la/cds-db-nlquery-mcp@0.7.3"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "MCP_ALLOWED_ENTITIES": "<YOUR_MCP_ALLOWED_ENTITIES>",
        "MCP_BLOCKED_COLUMNS": "<YOUR_MCP_BLOCKED_COLUMNS>"
      }
    }
  }
}

VS Code

Merge this local stdio configuration, replace every placeholder environment value, and restart VS Code. Koskamo has not executed this package.
VS Code configuration
{
  "servers": {
    "cds-db-nlquery-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@shahid.la/cds-db-nlquery-mcp@0.7.3"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "MCP_ALLOWED_ENTITIES": "<YOUR_MCP_ALLOWED_ENTITIES>",
        "MCP_BLOCKED_COLUMNS": "<YOUR_MCP_BLOCKED_COLUMNS>"
      }
    }
  }
}

Claude Desktop

Merge this local stdio configuration, replace every placeholder environment value, and restart Claude Desktop. Koskamo has not executed this package.
Claude Desktop configuration
{
  "mcpServers": {
    "cds-db-nlquery-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@shahid.la/cds-db-nlquery-mcp@0.7.3"
      ],
      "env": {
        "ANTHROPIC_API_KEY": "<YOUR_ANTHROPIC_API_KEY>",
        "OPENAI_API_KEY": "<YOUR_OPENAI_API_KEY>",
        "MCP_ALLOWED_ENTITIES": "<YOUR_MCP_ALLOWED_ENTITIES>",
        "MCP_BLOCKED_COLUMNS": "<YOUR_MCP_BLOCKED_COLUMNS>"
      }
    }
  }
}

Let your agent find its tools

Find servers like cds-db-nlquery-mcp from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.

Connect Koskamo Explore workflows
See all 7,692