Finance Control

To run the MPC server:

./gradlew bootRun

sqlite3

The server uses sqlite3 as its database.

The application will automatically create the database file finance.db if it does not exist and run the files for creating the tables and inserting sample data when the server starts. However, you can also set up the database manually using the provided SQL scripts.

To set up the database manually, run the following command in the terminal:

sqlite3 finance.db < src/main/resources/schema.sql

To insert sample data into the database, run the following command:

sqlite3 finance.db < src/main/resources/data.sql

You can access the database using command-line tools:

sqlite3 finance.db

## Once you are in the sqlite3 shell, you can run SQL commands to interact with the database. For example:
# To view the tables in the database
.tables

# To query data from a table (e.g., transactions)
SELECT * FROM finance;

MCP Inspector

You can debug the MCP server using the MCP Inspector.

npx @modelcontextprotocol/inspector

VSCode - MCP Client

In .vscode/mcp.json, you can configure the MCP client to connect to the server and send requests. For example:

{
  "servers": {
    "finance-mcp-server": {
      "url": "http://localhost:8080/sse",
      "type": "sse"
    }
  },
  "inputs": []
}