Skip to main content

Marker-indexed SQL cache MCP server

Project description

scry

Marker-indexed SQL cache MCP server. Scry indexes in-file @scry.* markers into a SQLite database that agents query via read-only SQL, providing structured project knowledge without LLM reasoning.

PyPI Python

Install

uv pip install scry-mcp
# or:
pip install scry-mcp

The PyPI distribution is scry-mcp (the bare name scry was already taken on PyPI). The import name and the installed console command are both scry.

Quickstart

# In your project root:
scry init                # scaffolds agent/ + driver dirs, updates .gitignore

Then add it to your MCP client config:

{
  "mcpServers": {
    "scry": {
      "command": "scry"
    }
  }
}

The MCP client inherits cwd from wherever it's launched, and scry walks up from there looking for an agent/ directory — so the same config works for any project. Bare scry (no subcommand) starts the MCP server over stdio — that's what Claude calls. Other subcommands:

Command Purpose
scry Run the MCP server (default).
scry init [path] Create agent/ + agent/drivers/@local/scry/{data,runtime,scripts}/ and a local .gitignore inside the driver dir. Idempotent — safe to run inside an ACP project.
scry surface [--force] One-shot batch reindex without booting the server.
scry version Print the package version.

The server walks up from cwd until it finds an agent/ directory; that becomes the project root. The cache lives at agent/drivers/@<namespace>/scry/data/project.db and is gitignored.

Markers

Scry recognizes five marker kinds. Block markers carry a YAML body between open/close tokens; line markers are single-line @scry.<kind> <id> <ref>.

<!-- @scry.doc
id: design.auth-flow~a1b2c3d4
kind: design
summary: >
  JWT auth middleware, token validation, refresh flow
status: active
weight: 0.85
tags: ["scope:auth", "topic:security"]
rationale: >
  Missing this causes auth bypass bugs
applies: modifying auth, adding protected endpoints
seeded_questions:
  - How does token refresh work?
@scry.doc.end -->

<!-- @scry.file
id: file.auth-middleware~e5f6a7b8
kind: middleware
summary: Express middleware that validates JWT on every request
status: active
weight: 0.7
@scry.file.end -->

<!-- @scry.anchor auth-check~f1e2d3c4
description: JWT validation point for protected routes
@scry.anchor.end -->
# @scry.impl validate-jwt~a1b2c3d4 spec.auth~xyz89012#FR3
# @scry.test jwt-expiry~b2c3d4e5 spec.auth~xyz89012#UT1

Block markers can be embedded in any host-language comment style (HTML, Python, JS, JSDoc, Rust, bare YAML). Comment prefixes are inferred from the YAML body — there is no per-language config.

MCP tools

Tool Purpose
scry_sql(query) Read-only SQL gateway. Rejects mutator keywords. Returns {results, row_count} JSON.
scry_mint(kind, prefix) Generate a collision-free ID and the marker schema.
scry_surface(force=false) Batch reindex from disk. force=true hard-deletes records whose source file no longer exists.
scry_scrub() Create a <branch>--clean git branch with all @scry.* markers stripped and agent/ removed.
scry_script(action, script?, params?) Discover and run validation scripts from src/scry/scripts/ and agent/drivers/@<ns>/scry/scripts/.

Database schema

Five marker-backed tables (scry__doc, scry__file, scry__anchor, scry__impl, scry__test) plus doc_relationship (with cycle detection) and migration. FTS5 is maintained via triggers on the source tables — no manual rebuild step.

The cache is fully reconstructable from disk via scry_surface. The DB is gitignored; after git pull, agents call scry_surface to rebuild.

Watcher

A daemon thread runs alongside the MCP server, watching the project tree with a 150 ms debounce window. A lock file at agent/drivers/@<ns>/scry/runtime/lock performs PID-based primary election so multiple sessions don't race writes. The primary instance runs a cold scan on startup; secondaries observe and wait.

On file deletion: docs and files are soft-deleted (missing_since set); anchors, impls, and tests are hard-deleted.

Tests

uv pip install -e ".[dev]"
pytest

43 unit tests cover the parser, SQL gateway, mint, surface, watcher plumbing, script discovery, and relationship cycle detection.

License

MIT — see LICENSE.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

scry_mcp-0.5.1.tar.gz (36.5 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

scry_mcp-0.5.1-py3-none-any.whl (35.5 kB view details)

Uploaded Python 3

File details

Details for the file scry_mcp-0.5.1.tar.gz.

File metadata

  • Download URL: scry_mcp-0.5.1.tar.gz
  • Upload date:
  • Size: 36.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.11.1 {"installer":{"name":"uv","version":"0.11.1","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.10","id":"oracular","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

File hashes

Hashes for scry_mcp-0.5.1.tar.gz
Algorithm Hash digest
SHA256 033040400f3957f1728d74a93c179a6c053fb81296153a7a11a4717262628a56
MD5 a727c9645eda35284137fe4215e42805
BLAKE2b-256 8e066f362604cb1e12fef3a4df5682248f946a801a6ffd18cb50440d56c2e63e

See more details on using hashes here.

File details

Details for the file scry_mcp-0.5.1-py3-none-any.whl.

File metadata

  • Download URL: scry_mcp-0.5.1-py3-none-any.whl
  • Upload date:
  • Size: 35.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.11.1 {"installer":{"name":"uv","version":"0.11.1","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.10","id":"oracular","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

File hashes

Hashes for scry_mcp-0.5.1-py3-none-any.whl
Algorithm Hash digest
SHA256 7cc7b2191425a982c466a75dc245aa84a8e42d0c29b8f00243f5696ba910a2f4
MD5 d40efaf361af6d6cceb571cd20e468f7
BLAKE2b-256 c05b2fd6b386bd81f3f0c8811cd57c98b3d27a6468a51641a0514fa7cdf127ae

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page