ddellecasedata/SQL-MCP
If you are the rightful owner of SQL-MCP and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to dayong@mcphub.com.
This document outlines the setup and features of a Model Context Protocol (MCP) server designed for automated inventory and task management using LLM technology, integrated with a PostgreSQL database.
Tools
Functions exposed to the LLM to take actions
aggiungere_alimento
Tool for adding food items to the inventory with various parameters.
consultare_giacenze
Tool for consulting stock levels with optional filters.
scaricare_alimento
Tool for registering food consumption with reasons and notes.
notifiche_scadenza
Tool for retrieving food items nearing expiration.
statistiche_consumi
Tool for generating consumption statistics over a specified period.
inserire_task
Tool for inserting tasks with various parameters including recurrence.
elencare_task
Tool for listing tasks with optional filters.
aggiornare_task
Tool for updating task details.
completare_task
Tool for marking tasks as completed, handling recurrences automatically.
statistiche_task
Tool for generating task completion statistics over a specified period.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client