1. Conduid
  2. Data
  3. Database Analytics MCP
MCP server · Data

Database Analytics MCP

by · github.com/khuyentran1401/database-analytics-mcp

Database Analytics MCP Server built with FastMCP - SQLite database operations with AI assistant integration

Unclaimed last commit a year ago data
InstallView source
34Low

Scored 6 months ago · breakdown

About Database Analytics MCP

Database Analytics MCP is an MCP server published by khuyentran1401 in the Data category: database Analytics MCP Server built with FastMCP - SQLite database operations with AI assistant integration.

The repository has 7 stars and 3 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues before depending on it in production.

Install

From source
git clone https://github.com/khuyentran1401/database-analytics-mcp

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Tools (4)

connect_db`database_path: str`

Parameters not published.

execute_query`sql: str`

Parameters not published.

export_to_csv`sql: str`, `filename: str`

Parameters not published.

list_tablesNone

Parameters not published.

Ask AI

✦

Ask AI about Database Analytics MCP

Powered by Claude · Grounded in docs

I know everything about Database Analytics MCP. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

  • ✓README presentThe repository ships documentation.

5 checks have not been run yet.

README

Database Analytics MCP Server

A practical database analytics MCP server built with FastMCP, providing SQLite database operations through the Model Context Protocol (MCP). Perfect for data analysis workflows with AI assistants like Claude.

What This Server Provides

🛠️ Tools (Interactive Operations)

  • connect_db - Connect to SQLite database files
  • execute_query - Execute SQL queries with safety checks
  • list_tables - List all tables in the database

📊 Resources (Read-only Data Access)

  • schema://tables/{table_name} - Get table column information and structure
  • data://tables/{table_name} - Get sample table data for preview

🔐 Safety Features

  • SQL injection prevention with dangerous operation blocking
  • Read-only resource access for safe schema exploration
  • Comprehensive error handling with descriptive messages

Setup and Installation

  1. Clone the repository:

    git clone https://github.com/khuyentran1401/database-analytics-mcp.git
cd database-analytics-mcp

  2. Install UV (recommended):

    # Install UV if you haven't already
curl -LsSf https://astral.sh/uv/install.sh | sh

  3. Install dependencies:

    # UV automatically manages dependencies from pyproject.toml
uv sync

  4. Test the server:

    uv run example_usage.py

  5. Add to Claude Code

    # Quick setup
claude mcp add database-analytics -- uv run database_mcp_server.py

    Verify installation:

    # Check if the server is registered
claude mcp list

Other MCP Clients

For any MCP client that supports the standard protocol:

servers:
  - name: database-analytics
    transport:
      type: stdio
      command: uv
      args: ["run", "database_mcp_server.py"]

Example Workflows

Data Exploration with Claude Code

  1. Connect to Database

    Connect to my SQLite database at ./sample_database.db

  2. Explore Schema

    What tables are available in this database?

  3. Examine Table Structure

    Show me the schema for the users table

  4. Preview Data

    Show me some sample data from the users table

  5. Run Analytics Queries

    Calculate total sales by product category

  6. Export Results

    Export the query "SELECT product_name, SUM(quantity) as total_sold FROM orders GROUP BY product_name" to CSV file called sales_report.csv

  7. Get Table Statistics

    Show me statistics for the users table

Common Use Cases

  • Database Schema Discovery: Quickly understand database structure
  • Data Quality Checks: Sample data to verify data integrity
  • Ad-hoc Analysis: Run custom SQL queries safely
  • Report Generation: Execute complex analytical queries
  • Data Exploration: Browse tables and relationships with pagination
  • Data Export: Export query results to CSV for external analysis
  • Performance Monitoring: Track query execution times

Available Tools & Resources

Tools (Interactive Operations)

Tool Parameters Description
connect_db database_path: str Connect to SQLite database file
execute_query sql: str Execute SQL query with safety checks and timing
list_tables None List all tables in connected database
export_to_csv sql: str, filename: str Export query results to CSV file

Resources (Read-only Access)

Resource URI Description
schema://tables/{table_name} Get column info, types, constraints, foreign keys
data://tables/{table_name} Get sample rows with pagination, statistics (limit, offset)
stats://tables/{table_name} Get comprehensive table statistics and column analysis

README copy captured when this server was indexed; it may lag the repository. The original is authoritative.

Questions

About Database Analytics MCP

How do I install Database Analytics MCP?

No package has been published for this server, so install it from source: clone the repository and follow its README.

Is Database Analytics MCP safe to use with an AI agent?

Its trust score is 34 out of 100 (low). It passes 1 of the 1 static security checks run so far. It has no ConduID identity yet, so agent calls to it are not receipted.

Is Database Analytics MCP still maintained?

The last commit was a year ago. That's long enough that you should check whether the maintainer is responding to issues before depending on it.