Ultimate Frisbee

You manage Ultimate Frisbee teams with a fast, flexible MCP server that handles players, tournaments, and federation payments. This server stores data in a local SQLite database or in SQLiteCloud, exposes a CLI for everyday tasks, and can be interacted with via an MCP client for streamlined automation and scripting.

How to use

You interact with the server through an MCP client or the built-in CLI. Common patterns include adding and listing players, creating tournaments, registering players for events, recording payments, and backing up your data. You can run the server locally, configure a cloud-backed database, and use environment variables to point the server at your data source. When you start the server, you’ll have a responsive interface to manage collections of players, tournaments, registrations, and payments.

How to install

# Prerequisites
- Python is not strictly required for the MCP CLI example here, but ensure you have a working shell.
- You will use the provided runtime command to start the MCP server locally.

# 1) Install dependencies and prepare environment
# Assuming you already have npm/uvx/pip available in your environment as shown in examples
# If you use a virtual environment tool, create and activate it as needed

# 2) Install development dependencies (if you are developing or testing the server)
uv pip install -e ".[dev]"  # example from the setup flow

# 3) Configure the environment (choose one)
# Local SQLite database
export SQLITE_URI=file:///path/to/your/database.db
# Or cloud-backed SQLiteCloud
export SQLITE_URI=sqlitecloud://host:port/database?apikey=your_api_key

# 4) Run tests (optional but recommended during setup)
pytest tests/

# 5) Start the MCP server locally
ultimate-team-mcp-server

Additional sections

Configuration and deployment notes help you tailor the server to your environment. You can run the server using a local database or connect to SQLiteCloud. The server supports a CLI for everyday operations and an MCP interface for integration with external tools.

Configuration and usage details

# Environment variables
SQLITE_URI="sqlitecloud://host:port/database?apikey=key" ultimate-team-mcp-server

# Alternative: local file-based DB
SQLITE_URI="file:///path/to/database.db" ultimate-team-mcp-server

Available tools

add_player

Add a new player with a name, phone, and optional email. Also allows batch operations via CSV imports.

list_players

List all players stored in the database.

remove_player

Remove a player by name from the database.

import_players

Import players from a CSV and update existing entries when a matching name is found.

add_tournament

Create a new tournament with name, location, date, surface type, and registration deadline.

list_tournaments

List all tournaments stored in the database.

update_tournament

Update details of an existing tournament by id.

remove_tournament

Delete a tournament by id.

register_player

Register a player for a specific tournament by id.

unregister_player

Unregister a player from a tournament by id.

list_tournament_players

Show all players registered for a given tournament.

list_player_tournaments

Show all tournaments a player is registered for.

mark_payment

Mark a player as having paid for a tournament.

clear_payment

Clear a player's payment status for a tournament.

search_paid_players

Search for players who have paid for a tournament with fuzzy name matching.

add_federation_payment

Record federation payments for a player including amount and date.

list_federation_payments

List all federation payments for a player.

remove_last_federation_payment

Remove the most recent federation payment for a player.

backup

Backup the database to a file.