filesystem-frontmatter-mcp
Verified Safeby kzmshx
Overview
An MCP server for querying Markdown frontmatter with DuckDB SQL, supporting optional semantic search for document embeddings.
Installation
uvx frontmatter-mcpEnvironment Variables
- FRONTMATTER_BASE_DIR
- FRONTMATTER_ENABLE_SEMANTIC
- FRONTMATTER_EMBEDDING_MODEL
- FRONTMATTER_CACHE_DIR
- MCP_TIMEOUT
Security Notes
The server employs robust path validation using `Path.resolve()` and `Path.relative_to(base_dir)` to prevent directory traversal attacks, ensuring all file operations are constrained to the configured `FRONTMATTER_BASE_DIR`. No hardcoded secrets or obvious malicious patterns were found. The primary security consideration is the `query` tool, which accepts arbitrary DuckDB SQL. While DuckDB operates in-process and primarily on local data within the defined base directory, allowing unvalidated SQL from an untrusted client could potentially expose local system information or be misused for local file manipulation within the DuckDB execution context. However, for a trusted developer environment, this provides flexibility. Semantic search involves downloading models from external sources (e.g., HuggingFace), which assumes the integrity of those sources.
Similar Servers
apple-health-mcp
Query and analyze personal Apple Health data using SQL for health insights and automated reports.
flapi
A fast and flexible API gateway powered by DuckDB, providing configurable HTTP and MCP endpoints for data access and management, with built-in caching, authentication, and rate-limiting features.
mcp-duckdb-memory-server
Manages and queries a knowledge graph using DuckDB as an embedded backend for AI agent memory, specifically designed for the Model Context Protocol.
duckdb_mcp
Integrate SQL databases with AI assistants (e.g., Claude) using the Model Context Protocol (MCP) for data querying, tool execution, and resource management.