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:
CapabilityDescription
Toolslist_tables, describe_table, and run_sql — let the AI discover schemas, inspect table structures, and execute read-only SQL
ResourcesBundled documentation covering supported SQL syntax and known limitations
PromptsGuided workflows for exploring data and writing queries

​
When to use MCP vs. the REST API

Use caseRecommended
AI assistant exploring and querying your data conversationallyMCP server
Application or script executing SQL programmaticallyREST API (Quickstart)
Both use the same API client credentials created in the DynamoSQL portal.

​
Server URL

https://mcp.dynamosql.com/mcp

​
Authentication

The MCP server uses OAuth 2.0 client_credentials for authentication. Your AI client obtains a bearer token from the /token endpoint using your API client credentials, then includes it on each MCP request. The MCP bearer token is separate from the REST API bearer token. See MCP Authentication for details.

​
Scopes

Scopes control which tools are available to the AI assistant:
ScopeTools enabled
queryrun_sql
schemas:readlist_tables, describe_table
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.
  • The server is stateless — each request is independent with no session state.
  • Bearer tokens expire after 10 minutes and must be refreshed by the MCP client.

​
Next steps