microsoft/MCP-Server-and-PostgreSQL-Sample-Retail
3.3
If you are the rightful owner of MCP-Server-and-PostgreSQL-Sample-Retail 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.
This MCP server provides secure and intelligent access to retail sales data through PostgreSQL, enabling AI assistants to perform advanced analytics.
Tools
Functions exposed to the LLM to take actions
get_multiple_table_schemas
Retrieve database schemas for multiple tables in a single request.
execute_sales_query
Execute PostgreSQL queries against the sales database with Row Level Security.
get_current_utc_date
Get the current UTC date and time in ISO format.
semantic_search_products
Perform a semantic search for products based on user queries.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client