Run read-only e-commerce analytics and generate collaborative filtering recommendations in Postgres.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "postgres-recommender-mcp" yet — see the docs or source repo.
Run read-only SQL analytics on the Postgres e-commerce database. Summarize weekly revenue, order count, and top 10 products by units sold over the last 90 days, and highlight notable trend changes.
Returns weekly sales summaries, a best-seller list, and key trend insights.
Using user-product interaction data in the e-commerce database, generate 10 product recommendations for user ID 1024 with ALS collaborative filtering, and include recommendation scores.
Returns a ranked list of recommended products, scores, and a brief explanation for business use.
Query users who purchased phones but not headphones, then use collaborative filtering results to identify the top 20 users most suitable for headphone recommendations, with a short rationale summary.
Outputs a target user list, recommended products, and priority levels for cross-sell campaigns.
Connect AI assistants to PostgreSQL for secure querying, management, and analysis.
Safely query, inspect, and analyze PostgreSQL databases in read-only mode.
Query PostgreSQL databases and schemas through natural language with read-only AI access.
Safely manage PostgreSQL databases with schema exploration, procedure analysis, and test data generation.
Safely explore PostgreSQL schemas and run controlled read or write queries.
Lets AI assistants run SQL and inspect PostgreSQL schemas via MCP tools.