Skip to main content
Glama

Semantic D1 MCP

Official

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
D1_DEV_DATABASE_IDYesYour development D1 database ID
D1_PROD_DATABASE_IDNoYour production D1 database ID (optional)
CLOUDFLARE_API_TOKENYesYour Cloudflare API token with D1 access
D1_DEV_DATABASE_NAMEYesYour development D1 database name
CLOUDFLARE_ACCOUNT_IDYesYour Cloudflare account ID
D1_PROD_DATABASE_NAMENoYour production D1 database name (optional)
D1_STAGING_DATABASE_IDNoYour staging D1 database ID (optional)
D1_STAGING_DATABASE_NAMENoYour staging D1 database name (optional)

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription
analyze_database_schema

Analyze D1 database schema structure, tables, columns, indexes, and relationships with optional sample data

get_table_relationships

Extract and analyze foreign key relationships between tables in the database

validate_database_schema

Validate database schema integrity and detect potential issues (missing primary keys, orphaned foreign keys, etc.)

suggest_schema_optimizations

Analyze schema and suggest performance optimizations (missing indexes, redundant indexes, etc.)

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/semanticintent/semantic-d1-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server