Schema | SQLite Read-Only MCP Server

SQLite Read-Only MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`SQLITE_DB_PATH`	Yes	The path to the SQLite database file

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{ "listChanged": false }
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
list_tablesA	List all tables in the database.
describe_tableA	Get the column schema (name, type, nullability, primary key) for one table. Args: table: Table name, as returned by list_tables.
queryA	Run a READ-ONLY SQL query (a single SELECT or WITH statement) and return the rows. Writes (INSERT/UPDATE/DELETE/DROP/...) are rejected. Results are capped at max_rows. Args: sql: A single SELECT or WITH statement. max_rows: Maximum number of rows to return (1-1000, default 100).

Interactive templates invoked by user choice

Name	Description
`explore_database`	A ready-made prompt to explore an unfamiliar database.

Contextual data attached and managed by the client

Name	Description
`schema_resource`	The full schema of the database, as readable text.

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

curl -X GET 'https://glama.ai/api/mcp/v1/servers/skycandykey1/mcp-sqlite-server'

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