LocalData MCP Logo

Contents

  • Getting Started
    • Installation
      • Using uv (recommended)
      • From source
      • What’s included
      • Additional database drivers
    • MCP client configuration
    • First steps
      • Connect to a local SQLite database
      • Open a CSV file
      • Navigate a JSON config file
      • Load and analyze a graph
    • Security
    • Next steps
  • LocalData MCP Tools Reference
    • Table of Contents
    • Core Database (8 tools)
      • connect_database
      • disconnect_database
      • execute_query
      • analyze_query_preview
      • list_databases
      • describe_database
      • find_table
      • describe_table
    • Streaming & Memory (9 tools)
      • next_chunk
      • manage_memory_bounds
      • get_streaming_status
      • clear_streaming_buffer
      • get_query_metadata
      • request_data_chunk
      • request_multiple_chunks
      • cancel_query_operation
      • get_data_quality_report
    • Tree/Structured Data (10 tools)
      • get_node
      • get_children
      • set_node
      • move_node
      • delete_node
      • list_keys
      • get_value
      • set_value
      • delete_key
      • export_structured
    • Graph Operations (7 tools)
      • get_neighbors
      • get_edges
      • add_edge
      • remove_edge
      • find_path
      • get_graph_stats
      • export_graph
    • Search & Transform (2 tools)
      • search_data
      • transform_data
    • Schema & Audit (3 tools)
      • export_schema
      • get_query_log
      • get_error_log
    • System (1 tool)
      • check_compatibility
    • Data Science (12 tools)
      • analyze_hypothesis_test
      • analyze_anova
      • analyze_effect_sizes
      • analyze_regression
      • evaluate_model_performance
      • analyze_clusters
      • detect_anomalies
      • reduce_dimensions
      • analyze_time_series
      • forecast_time_series
      • analyze_rfm
      • analyze_ab_test
    • Quick Reference Summary
    • Parameter Type Reference
    • Return Format Convention
    • Composition Patterns
      • Sequential Loading
      • Exploration Workflow
      • Data Transformation
      • Analysis Pipeline
  • Configuration
    • Config file locations
      • How merging works
    • Environment variables
      • General
      • Database connections
      • Staging
      • Memory
      • Query execution
      • Connections
      • Security
      • Disk budget
      • Aggressive memory
    • Configuration reference
      • databases
      • staging
      • disk_budget
      • memory
      • query
      • connections
      • security
      • logging
      • performance
    • Enterprise authentication
      • Supported methods by database type
      • Auth parameter examples
    • BLOB handling
      • Modes
      • Per-query override
    • Preflight query estimation
      • Response format
    • YAML variable substitution
    • Example configurations
      • Minimal
      • Development
      • Oracle
      • MS SQL Server
      • Production
    • Readonly mode
    • Tools reference (v1.7.0)
      • search_data
      • transform_data
      • export_schema
      • get_query_log
      • get_error_log
    • Graph export formats
    • Tree breadcrumb paths
    • Migration guide
      • Automatic migration
      • Manual migration
    • CLI flags
  • Data Sources
    • Flat Data Files
      • Supported formats
      • Available tools
      • Large result handling
      • Notes
    • SQL Databases
      • Supported databases
      • Available tools
      • Security considerations
    • Structured Data
      • Tree storage (JSON, YAML, TOML)
      • XML and INI (flat handling)
    • Directed Graphs
      • Supported formats
      • Graph tools
      • Validation warnings
    • LocalData MCP Data Sources Reference
      • Table of Contents
      • SQL Databases (6)
      • NoSQL Databases (6)
      • File Formats (8)
      • Spreadsheets (3)
      • Analytical Formats (4)
      • Graph Formats (4)
      • RDF & Semantic Web (3)
      • Authentication & Security
      • Connection Best Practices
      • Quick Reference Table
  • Data Science Domains
    • Available domains
      • Statistical Analysis Domain
      • Time Series Domain
      • Regression and Modeling Domain
      • Pattern Recognition Domain
      • Business Intelligence Domain
      • Geospatial Domain
      • Optimization Domain
      • Sampling & Estimation Domain
  • Error classification
    • Error categories
    • Retryability
    • Structured error response format
    • Database-specific mappings
      • SQLite
      • PostgreSQL
      • MySQL / MariaDB
      • DuckDB
      • Oracle
      • MS SQL Server
    • Integration guide
    • Helper functions
      • classify_error(exception, db_type="generic")
      • is_error_retryable(exception, db_type="generic")
      • get_error_suggestion(exception, db_type="generic")
  • Changelog
    • [2.0.0] - 2026-04-06
      • Added
      • Changed
    • [1.7.1] - 2026-04-02
      • Added
      • Fixed
      • Changed
    • [1.7.0] - 2026-03-28
      • Added
    • [1.6.0] - 2026-03-28
      • Added
    • [1.5.2] - 2026-03-26
      • Added
    • [1.5.1] - 2026-03-26
      • Added
      • Fixed
    • [1.5.0] - 2026-03-24
      • Added
      • Fixed
    • [1.4.2] - 2026-03-23
      • Fixed
    • [1.4.0] - 2026-03-23
      • Added
      • Fixed
    • [1.3.1] - 2025-08-31
      • Added
      • Changed
      • Fixed
    • [1.3.0] - 2025-08-30
      • Added
      • Changed
      • Fixed
    • [1.2.0] - 2025-08-29
      • Added
      • Changed
      • Fixed
    • [1.1.0] - 2025-08-23
      • Added
      • Changed
    • [1.0.3] - 2025-08-23
      • Fixed
    • [1.0.2] - 2025-08-23
      • Fixed
    • [1.0.1] - 2025-08-23
      • Fixed
    • [1.0.0] - 2025-08-23
      • Added
LocalData MCP
  • Data Sources
  • View page source

Data Sources

LocalData MCP supports four categories of data sources, each with its own storage model and tool set. See the complete reference for connection strings, authentication, and examples for all 30+ supported formats.

  • Flat Data Files
    • Supported formats
    • Available tools
    • Large result handling
    • Notes
  • SQL Databases
    • Supported databases
    • Available tools
    • Security considerations
  • Structured Data
    • Tree storage (JSON, YAML, TOML)
    • XML and INI (flat handling)
  • Directed Graphs
    • Supported formats
    • Graph tools
    • Validation warnings
  • LocalData MCP Data Sources Reference
    • Table of Contents
    • SQL Databases (6)
    • NoSQL Databases (6)
    • File Formats (8)
    • Spreadsheets (3)
    • Analytical Formats (4)
    • Graph Formats (4)
    • RDF & Semantic Web (3)
    • Authentication & Security
    • Connection Best Practices
    • Quick Reference Table
Previous Next

© Copyright 2025, Christian C. Berclaz.

Built with Sphinx using a theme provided by Read the Docs.