Skip to main content

​
What is MCP?

The Model Context Protocol (MCP) is an open standard that lets AI assistants connect to external data sources and tools. DynamoSQL provides an MCP server that gives AI assistants direct access to your DynamoDB data through schema discovery and read-only SQL execution.

​
What the DynamoSQL MCP server provides

The MCP server exposes three capabilities:

​
When to use MCP vs. the REST API

Both use the same API client credentials created in the DynamoSQL portal.

​
Server URL

​
Authentication

The MCP server supports two authentication modes: In both cases, the MCP bearer token is separate from the REST API bearer token. See MCP Authentication for details.
Interactive browser login supports three client-registration paths: exact pre-registration for known clients, Client ID Metadata Documents (CIMD), and Dynamic Client Registration (DCR) for public interactive clients. Every interactive login shows a DynamoSQL consent screen before the auth code is issued.

​
Scopes

Scopes control which tools are available to the AI assistant: Grant both scopes for full access. If a scope is not granted, the corresponding tools are not advertised to the AI assistant.

​
Behavioral notes

  • The MCP server is read-only. Only SELECT and WITH statements are accepted.
  • Query results are capped at 1000 rows (default 100).
  • Table listings are capped at 200 tables.
  • MCP request handling is stateless, but interactive OAuth uses short-lived server-side state for consent, authorization codes, refresh-token rotation, CIMD caching, and DCR registration.
  • Access tokens expire after 10 minutes.
  • Interactive browser login issues rotating refresh tokens with a 12-hour default session lifetime.

​
Next steps