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.
Query PostgreSQL databases and schemas through natural language with read-only AI access.
Safely explore PostgreSQL schemas and run controlled read or write queries.
Safely let AI query and analyze Postgres data in read-only mode.
Enable safe, scoped Postgres querying for AI with read-only access controls.
Safely access and diagnose PostgreSQL databases through structured MCP tools.