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.
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.
- Use Python 3.10 or 3.11 with uv and provision dedicated read-oriented database credentials.
- Set DB_USE_KEYSPACES and the endpoint/region, supply credentials securely and place the documented certificate under ~/.keyspaces-mcp/certs/.
- 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.
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/amazon-keyspaces-mcp-server/README.md
Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/amazon-keyspaces-mcp-server/pyproject.toml
Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports
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
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/README.md
Supports: summary, install, configExample, access, limitations, bestFor, review, compatibility, transports
- Applicable licence ↗Checked
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/LICENSE
Supports: license
https://github.com/awslabs/mcp/blob/8840003820a78dd018561d55c7ab12fcdd708464/src/amazon-keyspaces-mcp-server/awslabs/amazon_keyspaces_mcp_server/client.py
Supports: limitations, review