AOC AI Agents Book a consultation
Workflows / Data & Reporting / Databases
$12StandardAIAOC-DR-005

PostgreSQL MCP server for AI agents

Works as a tool for AI assistants (MCP) and works with PostgreSQL.

Main steps

  • GetTableSchema
  • ListTables
  • CreateTableRecords
  • ReadTableRecord
  • Operation
  • UpdateTableRecord

What you get

  • workflow.json – import into n8n (11 steps, starts from an AI assistant (MCP tool))
  • README setup guide and an in-workflow setup note

You need

  • n8n (Cloud or self-hosted)
  • PostgreSQL account