Explore an unfamiliar Fresha dataset
When you are unsure which reports your connector exposes, ask your assistant to list the available tables and views. You get the report names you can use to investigate your business questions.
Toolslist_
Overview
mcp-fresha connects your AI assistant to Fresha Data Connector through Snowflake. It lets you explore the available reports and retrieve business records, with filters for dates and other values. It is designed for read-only reporting on data such as bookings, clients, sales, payments and cash flow.
The server runs on your computer and needs the Snowflake connection details supplied in your Fresha Data Connector settings. Access to your business data depends on an active Data Connector.
- Sample data Mock mode provides sample data for development without Snowflake credentials; confirm that results come from your business before relying on them.
- Connector availability The project lists an eight-hour daily limit for Fresha Data Connector access, so check that the connector is active when querying.
Use Cases
Review cash flow for a period
For a daily or weekly financial review, retrieve cash-flow or payment records for the dates you need. Your assistant can bring the relevant transactions into the conversation for inspection.
Toolsget_
Check this week's bookings
When planning the week, ask for bookings within that date range. You get the appointment records for the period without retrieving the full booking history.
Toolsget_
Review sales at one location
When a sales question concerns one branch, filter the sales report by location. You get records for that location rather than a result spanning the whole business.
Toolsget_
Find your most frequent clients
When you want to identify clients who book most often, ask for the top ten clients by appointment count. The result gives you a focused list to review.
Toolsget_
Tools
get_fresha_report
Retrieve Fresha report data from Snowflake, such as bookings, sales or cash flow. Date ranges, custom filters, sorting and record limits help narrow the results to the records you need.
list_fresha_reports
Find which reports are available by listing the tables and views in your Fresha database, so you can choose what to query.
Install
Have the Snowflake account, username, password, database, schema and warehouse values from your Fresha Data Connector settings ready to configure the local server.
Installation categoriesConnect to your AI tool
Claude Desktop
- 01
Install mcp-fresha
Run this command on your computer with npm available.
Terminal on your computer npm install -g mcp-fresha - 02
Add your Fresha connection
In Claude Desktop, open Settings > Developer > Edit Config. Add the configuration below to the JSON file; if you already have an
mcpServersobject, add thefreshaentry inside it.Use the connection details from your Fresha Data Connector settings for all six values in
env: account, user, password, database, schema and warehouse. Replace the sample values with yours, keeping each value in double quotes. Enter the account withouthttps://.claude_desktop_config.jsonOpen through Settings > Developer > Edit ConfigJSON{ "mcpServers": { "fresha": { "command": "mcp-fresha", "env": { "SNOWFLAKE_ACCOUNT": "your-account.snowflakecomputing.com", "SNOWFLAKE_USER": "FRESHA_DATA_XXX_XXX", "SNOWFLAKE_PASSWORD": "your-password", "SNOWFLAKE_DATABASE": "FRESHA_DATA_CONNECTOR", "SNOWFLAKE_SCHEMA": "FRESHA_DATA_XXX", "SNOWFLAKE_WAREHOUSE": "FRESHA_DATA_XXX" } } } } - 03
Restart Claude Desktop
Save the configuration, completely quit Claude Desktop, then reopen it to load the configuration and start the server.
Check the result
Check that the Fresha tools appear
At the bottom-left of the conversation input, click “Add files, connectors, and more /”, then open Connectors > Manage connectors. Select fresha and check for list_fresha_reports and get_fresha_report.
Check access to your Fresha database
Ask Claude “Show me all tables” to use list_fresha_reports. Check that the returned tables and views match your Fresha database.
mcp-fresha installation and Snowflake configurationConnect local MCP servers to Claude Desktop