Skip to main content
Glama
WebRTCGame

SQLite Project Memory MCP

by WebRTCGame

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SQLITE_MCP_DB_PATHNoOverride the SQLite database file path. The default database path is data/project_memory.db under the repository root.
SQLITE_MCP_TRANSPORTNoThe transport protocol to use, either 'stdio' or 'streamable-http'.
SQLITE_MCP_EXPORT_DIRNoThe default output directory for generated markdown views.

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
get_project_contextA

Return the current project root, DB path, and export directory.

set_project_rootB

Switch project context (root + db + export path) and reconnect database.

server_infoB

Return server metadata and schema settings.

create_entityC

Create a new authoritative project entity.

upsert_entityC

Create an entity if missing or merge updates into an existing entity.

update_entityC

Update an existing entity's top-level state.

append_contentD

Add a piece of content to an entity.

archive_entityA

Archive an entity without deleting its history or related project memory.

delete_entityA

Delete an entity with guardrails; non-forced deletion requires prior archiving and no critical dependents.

merge_entitiesB

Merge a duplicate source entity into a target entity with deterministic conflict handling.

get_entityC

Fetch an entity and optionally include related metadata, content, and events.

list_entitiesC

List entities with optional type, status, attribute, tag, and text filters.

find_similar_entitiesB

Find likely duplicate or related entities before creating a new one.

resolve_entity_by_nameC

Resolve a human-readable name to an existing entity when possible.

get_or_create_entityB

Reuse an exact entity when it already exists or create one with a generated stable id.

upsert_attributesB

Create or update flexible metadata for an entity.

set_tagsC

Set or merge tag labels for an entity.

add_relationshipC

Create a typed graph edge between two entities.

connect_entitiesC

Create a relationship if missing, otherwise return the existing edge.

delete_relationshipB

Delete a relationship by id and record the removal in project history.

list_relationshipsC

List graph edges, optionally constrained to an entity and direction.

write_contentC

Write narrative content in one unified API with append|replace semantics.

search_contentC

Search narrative content using FTS5 when available.

create_snapshotC

Create a named snapshot of current project state.

get_snapshotB

Fetch a named snapshot and its captured entities.

list_viewsB

List available view names for query_view discovery.

query_viewB

Query a named SQL view for generic reporting and model projections.

get_database_healthB

Report likely duplicates, low-quality records, and retention pressure in project memory.

refresh_task_summaryB

Rebuild a task summary materialized table for faster open task queries.

apply_performance_tuningC

Tune SQLite settings for throughput during heavy project-memory workloads.

get_decision_logB

Return decisions and recent supporting note excerpts without requiring ad hoc SQL.

get_architecture_summaryB

Return a compact architecture-oriented node and relationship summary.

get_recent_reasoningC

Return recent reasoning excerpts for quick AI context recovery.

get_dependency_viewC

Return dependency-oriented graph data with stable compact fields.

get_recent_activityC

Return recent entities, content, and events to help an AI resume context quickly.

prune_content_retentionC

Prune older reasoning/log content while keeping the most recent records per entity and type.

get_entity_graphC

Traverse outward relationship dependencies from an entity.

bootstrap_project_memoryC

Initialize a project root entity and standard memory-area anchor entities.

run_read_queryC

Run a constrained read-only SQL query for diagnostics, analytics, and ad hoc retrieval.

render_markdown_viewsA

Render markdown document views only after an explicit user request for a human-readable artifact.

export_markdown_viewsB

Write generated markdown views only after an explicit user request for a human-readable artifact.

Prompts

Interactive templates invoked by user choice

NameDescription
project_memory_policyGuide an AI to store project memory cleanly and avoid data pollution.

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/WebRTCGame/SQLITE-MCP'

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