postgres

DeepSQL is a self-hostable AI DBA agent for Postgres and MySQL that monitors workloads, rewrites slow queries, recommends indexes and materialized views, and connects through CLI, MCP, and Slack.

Legion is an open-source Elixir runtime for AI agents that run inside your app, write code, and act on your data through sandboxed tools. It supports Lua or Elixir code execution, user-scoped actions, Postgres-backed persistence, and a LiveView dashboard for observability.

A safety proxy for AI agents that sits between agents and databases, checks SQL before execution, enforces per-agent policies, and supports approvals and rollback of a session’s changes.

Enterprise Postgres platform for AI apps, with managed, BYO cloud, and on-prem deployment options. It adds built-in MCP access for agents, pgvector and hybrid search for RAG, branching for isolated experiments, and a path from prototype to production.

Open-source structured memory for AI agents. Ingot stores tool results and documents in SQL-friendly form, with optional embeddings, MCP access, and a local quick start for running the stack.

dbq is a CLI for coding agents to run read-only SQL against Oracle, MySQL, Postgres, and SQL Server with token-light output and built-in safeguards.

A native macOS Postgres GUI that can draft SQL from natural-language questions, using either a configured cloud model or Apple’s on-device Foundation Model on supported Macs.

Lucidos is a local AI OS and companion that keeps described apps running, responds to events, and works from a persistent desktop or browser-based interface. The repo shows install paths for macOS and Linux, a headless runtime, source build instructions, and a clear focus on user-owned local data.

GeoSQL is a Claude, Codex, and GitHub Copilot skill that turns general-purpose agents into geospatial analytics assistants for PostGIS, BigQuery, Snowflake, and Wherobots. It runs locally or self-hosted, supports map-in-the-loop analysis, and includes install commands plus an eval suite.

Open-source AI SQL IDE for databases with a built-in AI data analyst, schema browser, notebook-based query runner, and persistent workspace state.

Otlet is a Postgres extension for running local LLM inference next to database rows. The README shows SQL examples, model registration, task execution, and an entity-resolution workflow with typed outputs.

Open-source context layer for analytics/data agents that builds warehouse context from approved metrics, joins, wiki knowledge, and semantic-layer sources, with CLI and MCP support.

Read-only Postgres MCP server that adds schema context files for more accurate agent answers and supports agents writing back table notes.

Polygres is a Postgres platform built for agent and retrieval workloads, combining hosted PostgreSQL with native graph traversal, HNSW vector search, and hybrid retrieval APIs. The page shows a working product site, SDK usage, API/runtime connection details, and example hybrid queries.

dbmachine turns a Postgres database into a self-describing backend that AI agents can operate through a CLI and YAML spec. It compiles schema, constraints, RLS, audit logging, and custom operations into a local Postgres setup.

FERNme is an open-source memory engine for AI agents that uses fuzzy graphs and Hebbian-style updates to store user preferences with near-zero LLM calls. The repository highlights editable user-owned memory, flat token usage, outcome-based reinforcement, and deployable plumbing via REST and MCP.