Skip to main content
Glama
shutterfly2011

mcp-db-server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
HOSTNoServer host0.0.0.0
PORTNoServer port8000
DB_HOSTNoDatabase hostlocalhost
DB_NAMENoDatabase namepostgres
DB_PORTNoDatabase port5432
DB_USERNoDatabase usernamepostgres
LLM_MODELNoModel name for the configured LLM provider.
DB_PASSWORDNoDatabase passwordpostgres
LLM_API_KEYNoAPI key for the LLM provider. Can be used as an alternative to ANTHROPIC_API_KEY, OPENAI_API_KEY, or OPENROUTER_API_KEY.
DATABASE_URLNoFull database connection URL (e.g., postgresql+asyncpg://user:password@host:5432/dbname, mysql+aiomysql://user:password@host:3306/dbname)postgresql+asyncpg://postgres:postgres@localhost:5432/postgres
LLM_BASE_URLNoBase URL for Ollama (or compatible) endpoint.http://localhost:11434
LLM_PROVIDERNoLLM provider to use for natural language to SQL conversion: anthropic, openai, openrouter, or ollama. If unset, uses rule-based fallback.
OPENAI_API_KEYNoOpenAI API key (alternative to LLM_API_KEY for OpenAI).
ANTHROPIC_API_KEYNoAnthropic API key (alternative to LLM_API_KEY for Anthropic).
OPENROUTER_API_KEYNoOpenRouter API key (alternative to LLM_API_KEY for OpenRouter).
ALLOW_WRITE_OPERATIONSNoSet to 'true' to enable potentially destructive write tools (execute_unsafe_sql, create_table, insert_data, update_data, delete_data).false

Capabilities

Server capabilities have not been inspected yet.

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

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/shutterfly2011/database-mcp-server'

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