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.

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.

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.