← Explore all mcp servers

AWS DATA SERVICES / AWS Labs

AWS Keyspaces MCP

Inspect Cassandra-compatible schemas and run SELECT queries with dedicated database credentials.

“MCP server for Amazon Keyspaces and Apache Cassandra schema and read-only CQL.”

01 / THE REASONING

Why this made the selection.

  • Specialized publisher integration with documented IAM and data access boundaries.
  • Discover table schemas before constructing a bounded SELECT query.
  • The README explores Keyspaces or Cassandra schemas and runs read-only CQL SELECT queries.
  • It uses username and password authentication and says it does not itself mutate Keyspaces, while also saying it cannot stop the agent from calling the AWS SDK another way.

02 / THE REVIEW RECORD

What we actually inspected.

Source review has boundaries.
A clear record is more useful than a “safe” badge.

Material inspected

  • src/amazon-keyspaces-mcp-server/README.md
  • src/amazon-keyspaces-mcp-server/pyproject.toml
  • src/amazon-keyspaces-mcp-server/awslabs/amazon_keyspaces_mcp_server/server.py
  • Root README.md and LICENSE
  • awslabs/amazon_keyspaces_mcp_server/client.py: TLS context and certificate fallback
  • LICENSE

Our findings

  • Package metadata constrains Python below 3.12, and README explicitly requires username/password rather than only the generic AWS profile.
  • server.py checks SELECT syntax and unsafe-operation strings before delegating to its data service.
  • The pinned TLS context retains default certificate-chain verification but sets check_hostname=False. Certificate-file load failure is logged and falls back to default CAs; no live TLS security test was performed.
  • The server lists keyspaces and tables and executes CQL SELECT queries against Amazon Keyspaces or Apache Cassandra, plus query-performance notes.
  • It authenticates with a username and password. Queries are limited to read-only SELECT statements.
  • The README says the server does not mutate Keyspaces data or resources, and also says it cannot prevent the agent from attempting mutating AWS SDK operations. Python 3.12+ is not fully supported.

Not established by this review

  • Server startup, authentication, live tool execution and security isolation were not tested.
  • Published package/container parity with a source revision and hosted implementation internals were not tested.
  • The server was not started and its tools were not called.
  • A pin does not verify transitive dependencies.
  • No tools/list or tool call was made.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

Connect a server deliberately.

Upstream setup instructions ↗

DOCUMENTED COMMAND

uvx awslabs.amazon-keyspaces-mcp-server@latest

Copying does not execute this command. It may retrieve a newer version than the reviewed source.

  1. Use Python 3.10 or 3.11 with uv and provision dedicated read-oriented database credentials.
  2. Set DB_USE_KEYSPACES and the endpoint/region, supply credentials securely and place the documented certificate under ~/.keyspaces-mcp/certs/.
  3. Start the local server, inspect keyspaces/tables and issue bounded SELECT queries against the intended keyspace.

Before you start

  • Python 3.10 or 3.11, uv/uvx and a stdio MCP client.
  • A reachable Keyspaces or Cassandra deployment, database credentials and the documented TLS certificate for Keyspaces.

Documented configuration example

Use the client and authentication context described in the setup guidance. Configuration formats vary between hosts.

{
  "mcpServers": {
    "awslabs-keyspaces": {
      "command": "uvx",
      "args": [
        "awslabs.amazon-keyspaces-mcp-server@latest"
      ],
      "env": {
        "DB_USE_KEYSPACES": "true",
        "DB_KEYSPACES_ENDPOINT": "cassandra.us-east-1.amazonaws.com",
        "DB_KEYSPACES_REGION": "us-east-1",
        "DB_CASSANDRA_USERNAME": "YOUR_SERVICE_USERNAME",
        "DB_CASSANDRA_PASSWORD": "YOUR_SERVICE_PASSWORD"
      }
    }
  }
}

04 / FOLLOW THE EVIDENCE

The source trail.

Our notes are separate from the original resource.
Check upstream before adopting a new version.

  1. https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/amazon-keyspaces-mcp-server/README.md

    Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports

  2. https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/amazon-keyspaces-mcp-server/pyproject.toml

    Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports

  3. https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/amazon-keyspaces-mcp-server/awslabs/amazon_keyspaces_mcp_server/server.py

    Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports

  4. https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/README.md

    Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports

  5. Applicable licence ↗Checked

    https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE

    Supports: license

  6. https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/amazon-keyspaces-mcp-server/awslabs/amazon_keyspaces_mcp_server/client.py

    Supports: limitations, review

Evidence & Ask