mydata
Syncs Strava activities (runs, rides, swims, etc.) into a local SQLite database for querying and analysis.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@mydataShow me my latest 5 transactions"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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.
This server cannot be deployed
Maintenance
Related MCP Connectors
Query 40 databases from Claude, ChatGPT, or Cursor — on any device. Read-only, encrypted, audited.
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.
Ask data questions in natural language. Get SQL, insights, and charts from your databases.
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