{
  "markdown": "# MCP Data Analysis Agent\n\nSafe, read-only SQLite and PostgreSQL analysis for coding agents.\n\n## Start with one instruction\n\nTell your agent:\n\n> **Please install from https://github.com/hassanvfx/mcp-data-analysis-agent.**\n\nIt installs MCP Data Analysis once as a credential-free global MCP server. It does **not** create a database, configure a source, or change your current project.\n\nThen open the full guide: [Getting started and project configuration](https://hassanvfx.github.io/mcp-data-analysis-agent/).\n\n## The two-stage workflow\n\n| Once per machine | Once per data project folder |\n| --- | --- |\n| Install the executable and machine-local absolute MCP client entries. | Configure that folder’s private `.mcp-data-source`. |\n| No database URL or credential is stored globally. | The file holds exactly one SQLite path/URL or PostgreSQL URL. |\n| Reuse the MCP server across projects. | Run preflight, inspect schema, and analyze that project’s data. |\n\nMove into the separate folder containing the data you want to analyze before the next step.\n\n```bash\ncd /path/to/data-project\n```\n\nChoose one project action:\n\n| Tell your agent | Result |\n| --- | --- |\n| **Please configure this folder.** | Deterministically initializes `.mcp-data-agent/`, then creates or opens `.mcp-data-source` and runs preflight. |\n| **Please install demo in this folder.** | Initializes the hidden workspace and creates the deterministic retail demo only in this folder. |\n| **Please enable MCP Data Analysis for this Cline project.** | Activates Cline's visible runtime settings for this one project, then tells you to reload VS Code. |\n\nThe canonical commands are:\n\n```bash\n# Real source: writes an ignored, mode-0600 .mcp-data-source file.\nmcp-data-cli configure-source /absolute/path/to/analytics.sqlite --yes\n\n# Or activate the deterministic retail demo for the current folder.\nmcp-data-cli demo start --yes\n\n# Confirm a bounded, read-only connection probe succeeds.\nmcp-data-cli preflight\n```\n\n## Supported databases and safety\n\n- **SQLite:** an absolute local path or local SQLite URL.\n- **PostgreSQL:** a `postgres://` or `postgresql://` URL using a dedicated database-level read-only account.\n- **Not supported:** MySQL and other database dialects.\n\n`.mcp-data-source` is the project’s runtime connection secret. Keep it regular (not a symlink), one line only, mode `0600`, and out of version control. Global MCP configuration never contains a database URL or `MCP_DATA_SOURCE_URL`.\n\nThe first project-specific configure or demo action creates `.mcp-data-agent/`: its empty versioned workspace, schema cache, managed demo, and durable observability ledger. If you created `.mcp-data-source` manually, run `mcp-data-cli prepare-workspace --yes` before preflight. The project root must be writable; `workspace_initialization_required` tells you to prepare it, while `PROJECT_STATE_UNAVAILABLE` tells you to choose a writable regular folder. MCP never runs a query without its task and receipt evidence. Legacy root-level `observability/` and `.mcp-data/` locations are not read, migrated, or removed.\n\nAfter `preflight` returns `ready`, ask the agent to inspect schema or run a bounded governed query. For the demo:\n\n```bash\nmcp-data-cli schema data\nmcp-data-cli query data 'SELECT id, name, stock FROM products ORDER BY id' --limit 10\n```\n\n## Installation commands\n\nPublic install:\n\n```bash\ncurl -fsSL https://raw.githubusercontent.com/hassanvfx/mcp-data-analysis-agent/main/install.sh | bash\n```\n\nIf you already cloned this checkout:\n\n```bash\n./install.sh --local\n```\n\nThe installer configures supported global client entries for Codex, Claude Code, Copilot, Cline, Cursor, Windsurf, and Continue. Each global entry uses the verified absolute path of this machine’s installed `mcp-data-mcp`, avoiding editor PATH issues while still containing no database secret. For complete client compatibility, demo cleanup, project-scoped fallback setup, Cline VS Code reload guidance, and operations details, use the [hosted guide](https://hassanvfx.github.io/mcp-data-analysis-agent/).\n\n### Cline in VS Code\n\nCline's visible MCP settings are global to the editor host, so activate one project explicitly after opening that folder:\n\n```bash\nmcp-data-cli cline activate --project-root /absolute/path/to/data-project\nmcp-data-cli cline activate --project-root /absolute/path/to/data-project --apply --yes\n```\n\nThis writes only the absolute MCP executable, `--project-root`, and `.mcp-data-source` to every detected Cline runtime file; it never writes a database URL or environment secret. Run **Developer: Reload Window** in VS Code, then open Cline → MCP Servers. Switching projects requires activation again. Use `mcp-data-cli cline status` to inspect the exact files and their managed state. `.cline/mcp.json` is a legacy project-local file and is not treated as Cline's active VS Code configuration.\n\n## Remove it from all agents\n\nTell your agent: **“Please uninstall MCP Data Analysis from all agents.”** It previews exact managed global entries and managed demos first. After you confirm the preview, it runs:\n\n```bash\nmcp-data-cli uninstall --all\nmcp-data-cli uninstall --all --apply --yes\n```\n\nAdd `--project-root /absolute/path/to/project` for every project-scoped fallback entry you also want removed. Cleanup never deletes custom sources, databases, governance files, observability evidence, or unrelated client settings.\n\n## More information\n\n- [Hosted getting-started guide](https://hassanvfx.github.io/mcp-data-analysis-agent/)\n- [Operational reference](docs/OPERATIONS.md)\n- [Security policy](docs/SECURITY.md)\n",
  "bytes": 5605,
  "sha": "c0309cd3944af7ac1c56905a208896ee77786ebffbc2d4ff280e6a4064d7e37f",
  "repo_slug": "hassanvfx/mcp-data-analysis-agent",
  "fonte": "repo",
  "truncated": false,
  "api": "https://agentalog.com/api/listings/okf_hassanvfx_mcp_data_analysis_agent_knowle_f066d898/readme"
}