jodur/mcp-addon-postgresql-homeassistant
3.3
If you are the rightful owner of mcp-addon-postgresql-homeassistant 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.
The PostgreSQL MCP Server for Home Assistant is an addon that facilitates secure and authenticated access to a PostgreSQL database using the Model Context Protocol, integrated with Home Assistant's authentication system.
Tools
Functions exposed to the LLM to take actions
listTables
Lists all tables in the database with schema information.
queryDatabase
Execute read-only SQL queries.
executeDatabase
Execute write operations (INSERT, UPDATE, DELETE, DDL).
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client