Schema | SQLite MCP Server

SQLite MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
No arguments

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

Functions exposed to the LLM to take actions

Name	Description
read_query	Execute a read-only SQL query (SELECT, WITH/CTE, or EXPLAIN). Use this for fetching data.
write_query	Execute a data modification query (INSERT, UPDATE, DELETE, REPLACE). Returns affected row count.
create_tableB	Create a new table in the database with a full CREATE TABLE SQL statement.
drop_table	Drop (delete) a table from the database. This action is irreversible.
list_tables	List all user-created tables in the database.
describe_table	Get the schema of a table: columns, types, constraints, indexes, and foreign keys.
append_insight	Add a business insight to the insights memo resource. Useful for recording observations from analysis.

Interactive templates invoked by user choice

Name	Description
`mcp-demo`	A guided walkthrough that creates tables, inserts sample data, and runs queries for a given topic

Contextual data attached and managed by the client

Name	Description
`Database Schema`	Complete schema of all tables in the SQLite database
`Business Insights Memo`	Accumulated business insights from data analysis

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

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

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