frontmatter-mcp
by kzmshx
Overview
An MCP server for querying Markdown frontmatter with DuckDB SQL, with optional semantic search capabilities.
Installation
uvx frontmatter-mcpEnvironment Variables
- FRONTMATTER_BASE_DIR
- FRONTMATTER_ENABLE_SEMANTIC
- FRONTMATTER_EMBEDDING_MODEL
- FRONTMATTER_CACHE_DIR
- MCP_TIMEOUT
Security Notes
The server exposes powerful file system and database operations. The `query` tool directly passes user-provided SQL to DuckDB, which is susceptible to SQL injection if the input is not sanitized by the calling client or if the MCP client itself is compromised. Batch file modification tools use `glob` patterns, allowing broad access to files within the `FRONTMATTER_BASE_DIR`, although `_resolve_path` prevents operations outside this directory. Semantic search dependencies download large models from the internet; while configured to a default, an attacker might attempt to manipulate the `FRONTMATTER_EMBEDDING_MODEL` environment variable to load a malicious model.
Similar Servers
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.
doc-hub-mcp
Provides offline, local Markdown document retrieval and resource reading capabilities for IDEs, Agents, or debugging tools, primarily focused on WeChat Work and Feishu developer documentation.
markitdown-mcp
Converts various document and media formats to Markdown using the Model Context Protocol (MCP), primarily for integration with AI workflows like Claude Desktop.