SQLite MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
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
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {} |
| prompts | {} |
| resources | {} |
Tools
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. |
Prompts
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 |
Resources
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 |
TDQS
Scored across 1 tool
With only one tool, there is no possibility of confusion between tools. The single tool's purpose is clearly distinct by default.
With a single tool, naming consistency is trivially maintained. The name 'create_table' follows a clear verb_noun pattern.
A single tool for a SQLite server is far too few for the apparent scope. Typical database operations are missing, making the tool set feel extremely thin.
The server only supports table creation, lacking essential operations like querying, inserting, updating, deleting, or dropping tables. This represents significant gaps for any database interaction.