Skip to main content
Glama
local-study-app

local-study-app

by resace3

Local Study App

A local-first, open-source flashcard and quiz app with a FastAPI website and a stdio MCP server for Codex. It uses SQLite, binds only to 127.0.0.1, and has no telemetry or runtime CDN dependencies.

Windows quick start

cd mcp-local-study-app
powershell -ExecutionPolicy Bypass -File scripts/install.ps1
powershell -ExecutionPolicy Bypass -File scripts/start.ps1
Start-Process http://127.0.0.1:8080

Python 3.9+ is supported. Data is stored in %LOCALAPPDATA%\local-study-app\study.db (override with STUDY_DATA_DIR). The MCP server is launched with python -m local_study_app.mcp_server from any directory.

Related MCP server: flashlearn-mcp

Architecture

FastAPI serves a single-page vanilla JavaScript UI and JSON API. SQLite stores decks, cards, reviews, quiz sessions, and activity. The MCP server wraps the same service layer and communicates over stdio. The app never binds beyond localhost and does not contact external services.

MCP installation

codex mcp add local-study-app -- "C:\path\to\mcp-local-study-app\.venv\Scripts\python.exe" -m local_study_app.mcp_server
codex mcp list

Tools include website lifecycle (start_study_app, open_study_app, get_study_app_status, stop_study_app), deck/card CRUD, quiz generation/submission, reviews/progress, and JSON/CSV import/export.

Example prompts: “Show me my cards due today.” “Generate a quiz from Biology Basics.” “Open my local study website.” “Export my Spanish deck as CSV.”

Tests and scripts

powershell -ExecutionPolicy Bypass -File scripts/test.ps1
powershell -ExecutionPolicy Bypass -File scripts/stop.ps1
powershell -ExecutionPolicy Bypass -File scripts/uninstall.ps1

The test suite covers persistence, CRUD, imports/exports, quiz scoring, spaced repetition, health, process idempotence, and MCP tool contracts. Screenshots and the MCP test report live under docs/.

Security

Inputs are typed and validated, SQL uses parameterized queries, HTML is rendered with text nodes, uploads are size-limited and parsed before commit, and import/export filenames are constrained to the application data directory. There is no generic shell MCP tool, analytics, cloud sync, or arbitrary file access.

License

MIT.

Available Tools

19 tools
create_deckD

Local study app tool

create_flashcardC

Local study app tool

delete_deckD

Local study app tool

delete_flashcardD

Local study app tool

duplicate_deckD

Local study app tool

export_deckC

Local study app tool

generate_quiz_from_deckD

Local study app tool

get_deckC

Local study app tool

get_due_cardsD

Local study app tool

get_study_app_statusD

Local study app tool

get_study_progressD

Local study app tool

import_deckC

Local study app tool

list_cardsD

Local study app tool

list_decksD

Local study app tool

open_study_appD

Local study app tool

record_card_reviewD

Local study app tool

start_study_appD

Local study app tool

stop_study_appC

Local study app tool

update_deckD

Local study app tool

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    C2.1/5.0

    Scored across 19 tools

    Disambiguation4/5

    Most tools have distinct purposes, but 'start_study_app' and 'open_study_app' may be ambiguous. Overall, the set is clear.

    Naming Consistency5/5

    All tools use consistent snake_case with a verb_noun pattern, making naming predictable.

    Tool Count4/5

    19 tools is slightly above typical range but justified by the app's scope including CRUD, study features, and app management.

    Completeness2/5

    Missing update_flashcard and get_flashcard, which are standard operations. This gap could cause agent failures when needing to update a specific flashcard.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      Not graded
      quality
      D
      maintenance
      Local Leitner flashcard MCP server enabling AI clients to create decks, manage cards, study with spaced repetition, and track progress.
      MIT
    • A
      license
      Not graded
      quality
      A
      maintenance
      Enables AI clients to create spaced-repetition flashcards from material being learned, quiz users aloud, grade answers, and schedule reviews using the FSRS algorithm through a self-hosted MCP server.
      8
      AGPL 3.0