Skip to main content
Glama
ofershap

mcp-server-sqlite

by ofershap

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
query

Execute a SQL query against a SQLite database. Returns results as a formatted table. Read-only by default.

schema

Get the schema of a SQLite database: all tables with columns and row counts.

table_info

Get detailed info about a single table: columns, types, constraints, and row count.

explain

Explain the query plan for a SQL query (EXPLAIN QUERY PLAN). Helps optimize queries.

list_databases

List all SQLite database files (.db, .sqlite, .sqlite3) in a directory.

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/ofershap/mcp-server-sqlite'

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