mcp_postgres

HemantaPatil/mcp_postgres

3.2

If you are the rightful owner of mcp_postgres 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.

The USDA Nutrition Database MCP Server provides intelligent access to the USDA nutrition database, transforming complex nutrition data into conversational queries for AI assistants.

Tools

Functions exposed to the LLM to take actions

execute_query

Execute custom SQL queries on the database.

list_tables

List all available database tables.

describe_table

Get schema information for any table.

get_table_sample

View sample data from any table.

search_foods

Search foods by keyword in names/descriptions.

get_nutrition_profile

Get complete nutrition data for a specific food.

get_foods_by_category

Browse foods within specific categories.

get_food_categories

List all food categories with counts.

compare_foods_nutrition

Compare nutrition between multiple foods.

find_foods_high_in_nutrient

Find foods with highest amounts of specific nutrients.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources