mydata
Syncs Strava activities (runs, rides, swims, etc.) into a local SQLite database for querying and analysis.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
MyData - Personal Data Hub
Sync personal data from various services into a local SQLite database. Query your data with SQL or let Claude help you analyze it via MCP tools.
Supported Integrations
Lunch Money - Transactions, categories, assets, recurring items
Strava - Activities (runs, rides, swims, etc.)
Related MCP server: SQLite MCP Server
Setup
1. Install dependencies
npm install
npm run build2. Configure environment variables
# Lunch Money - Get your API key from https://my.lunchmoney.app/developers
export LUNCHMONEY_API_KEY=your_api_key
# Strava - Create an app at https://www.strava.com/settings/api
export STRAVA_CLIENT_ID=your_client_id
export STRAVA_CLIENT_SECRET=your_client_secret
# Hevy
export HEVY_API_KEY=3. Authenticate with OAuth services
# Start OAuth flow for Strava
npm start -- auth stravaCLI Usage
# Sync all configured integrations
npm start -- sync
# Sync specific integration
npm start -- sync lunchmoney
npm start -- sync strava
# Query the database
npm start -- query "SELECT * FROM lm_transactions LIMIT 10"
# Check status
npm start -- statusMCP Server
Add to your Claude Desktop config (~/Library/Application Support/Claude/claude_desktop_config.json):
{
"mcpServers": {
"mydata": {
"command": "node",
"args": ["/path/to/mydata/dist/mcp-server.js"],
"env": {
"MYDATA_DB_PATH": "/path/to/mydata/data/mydata.db"
}
}
}
}Available MCP Tools
query_database- Execute SQL queries against your datalist_tables- Show all tables and their schemasdescribe_table- Get detailed schema for a specific tableget_sync_status- Show last sync time for each integration
Data Storage
All data is stored in a local SQLite database at ./data/mydata.db. This file is gitignored by default.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Query 40 databases from Claude, ChatGPT, or Cursor — on any device. Read-only, encrypted, audited.
Read-only Google Ads, GA4 and Search Console data for Claude, with no Google Cloud setup.
Connect Claude to your Intervals.icu watch data for fitness, workout review, and plan writing.
Query your warehouse or a CSV with Claude/ChatGPT over MCP, governed by table-level ACL + audit.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceProvides Claude Desktop with secure access to multiple database connections, allowing users to query MySQL, PostgreSQL, SQLite, and SQL Server databases directly through natural language.-
- AlicenseNot gradedqualityDmaintenanceEnables natural language interaction with local SQLite databases through Claude Desktop, translating plain English queries into SQL for data analysis and exploration.3MIT
- FlicenseNot gradedqualityBmaintenanceConnects Claude Desktop to your Garmin Connect running data stored locally in SQLite, enabling querying, syncing, and AI analysis of fitness activities.1-
- AlicenseNot gradedqualityFmaintenanceEnables connecting to any SQL database, exploring schemas, running queries, and visualizing results with interactive charts from Claude Desktop.MIT