Skip to main content
Glama
readonly-sql-mcp

readonly-sql-mcp

by EliasOlie

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
MAX_ROWSNoHard cap per page. Defaults to `500`.500
AUDIT_LOGNoAudit file. Defaults to `./audit/queries.jsonl`../audit/queries.jsonl
ORACLE_DSNNoOracle DSN.
ORACLE_USERNoOracle username.
SQL_DIALECTNoSQL dialect: `postgres`, `oracle` or `sqlite` (also the sqlglot dialect). Defaults to `postgres`.postgres
DATABASE_URLNoPostgres/SQLite connection string.
ALLOWED_TABLESNoComma-separated allowlist; include `information_schema.tables,information_schema.columns` if you use the metadata tools. Defaults to any table.
GATEWAY_TOKENSNoOne hashed token per agent: `name:sha256(token):permissions`.
AUTH_VERIFY_URLNoCentral identity service; overrides `GATEWAY_TOKENS`.
ORACLE_PASSWORDNoOracle password.
STATEMENT_TIMEOUT_MSNoPer-query timeout (Postgres). Defaults to `15000`.15000

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

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