mcp-fresha
If you are the rightful owner of mcp-fresha and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MCP (Model Context Protocol) server for accessing Fresha Data Connector via Snowflake, enabling direct querying of Fresha business data through AI assistants like Claude.
The mcp-fresha server is designed to facilitate seamless access to Fresha business data by leveraging the Snowflake data platform. It allows users to query their business data directly through AI assistants, providing real-time insights and analytics. The server is built with TypeScript, ensuring type-safe operations and maintainability. It supports flexible querying options, including date ranges, custom filters, sorting, and pagination. The server also features smart date parsing, allowing users to input natural language dates like 'yesterday' or 'last week'. Comprehensive schema discovery is another key feature, automatically identifying all available tables and their structures. For development purposes, a mock mode is available, providing sample data when Snowflake credentials are not accessible. The server emphasizes security, with best practices such as environment variable storage for sensitive credentials, read-only access, and parameterized queries to prevent SQL injection.
Features
- Real-time Data Access: Direct connection to Fresha business data through Snowflake.
- Flexible Querying: Support for date ranges, custom filters, sorting, and pagination.
- Smart Date Parsing: Natural language date inputs like 'yesterday', 'last week', 'this month'.
- Comprehensive Schema Discovery: Automatic discovery of all available tables and their structures.
- Mock Mode: Development mode with sample data when Snowflake credentials are not available.
Tools
list_fresha_reports
Lists all available tables and views in your Fresha database.
get_fresha_report
Get data from any Fresha report/table with flexible filtering options.