A
licenseA
qualityB
maintenanceMCP server for structured daily work diary management, enabling entries, standup summaries, weekly reports, full-text search, and automatic git commits.
14
MIT
timesheet-data
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., "@timesheet-datashow me today's checkpoints"
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.
Timesheet Data MCP
MCP server that provides work checkpoint querying and timesheet report storage for AI assistants. Part of a personal AI-powered time tracking system — reads checkpoints logged via the Work Checkpoints Raycast extension and stores finalized timesheet reports in a local SQLite database.
How it fits together
┌─────────────────────┐
│ Raycast Extension │ ← work-checkpoints
│ (logs checkpoints) │
└────────┬────────────┘
│ writes
▼
checkpoints.json ← flat file, local only
│
│ reads
▼
┌─────────────────────┐
│ MCP Server │ ← this repo
│ (this repo) │
└────────┬────────────┘
│ exposes tools to
▼
Claude Desktop ← generates timesheet from checkpoints
│
│ saves finalized reports
▼
timesheet.db ← SQLite databaseRelated MCP server: timedoctor-mcp
Tools
Checkpoint tools (read from JSON)
Tool | Description |
| Returns all checkpoints for today |
| Returns checkpoints for a given date |
| Returns all checkpoints |
Timesheet tools (read/write SQLite)
Tool | Description |
| Save a finalized report for a date (replaces any existing entries) |
| Update one or more fields of an existing entry by ID |
| Get all entries for a specific date |
| Get all entries within a date range |
| Hours and percentage breakdown by category, with client work split |
| Category breakdown grouped by week (Mon–Fri) for trend charts |
Categories
Entries are classified as: client_project, client_maintenance, internal_dev, or non_billable.
Setup
npm install
npm run buildAdd to your Claude Desktop config (claude_desktop_config.json):
{
"mcpServers": {
"timesheet-data": {
"command": "node",
"args": ["/path/to/timesheet-data-mcp/dist/index.js"],
"env": {
"CHECKPOINTS_PATH": "/path/to/checkpoints.json"
}
}
}
}CHECKPOINTS_PATH(required) — path to thecheckpoints.jsonfile synced by the Raycast extensionTIMESHEET_DB_PATH(optional) — defaults to~/Library/Application Support/timesheet-assistant/timesheet.db
The database and table are created automatically on first run.
Scripts
Script | Description |
| Compile TypeScript |
| Run tests |
| Check for lint and format issues |
| Auto-fix lint issues |
| Auto-format source files |
Related
work-checkpoints — Raycast extension that logs the checkpoints
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
MCP server providing attendance data queries via the CloudTime API.
- mcp-serverOAuthio.klokin
MCP server exposing klokin time-tracking operations (employees, time entries, stores) to AI clients.
Hosted MCP server for task-first delegation to remote workstations and workers.
MCP server for Withings health data — sleep, activity, heart, and body metrics.
Related MCP Servers
- AlicenseBqualityCmaintenanceMCP Server for extracting Time Doctor time tracking data via AI assistants.42MIT
- AlicenseAqualityBmaintenanceMCP server for Kimai time-tracking that provides read access to the full API and guarded write tools for timesheets, with explicit authorization and backups.2822AGPL 3.0
- AlicenseAqualityBmaintenanceA read-only MCP server for querying Timely time tracking data, providing tools for project overviews, time spent summaries, and work log entries.3MIT