dolthub/dolt
Dolt is a SQL database with Git-like version control capabilities, enabling users to manage, version, and collaborate on data and schemas as easily as code in Git repositories.
timescale/pg-aiguide
pg-aiguide is a specialized MCP (Model Context Protocol) server and Claude plugin designed to enhance AI coding tools' ability to generate high-quality PostgreSQL code. It addresses common issues in AI-generated Postgres code such as outdated syntax, missing constraints and indexes, lack of awareness of modern PostgreSQL features, and deviation from real-world best practices. By providing deep, version-aware semantic search capabilities across the official PostgreSQL manual and curated, opinionated Postgres best practices (referred to as "skills"), pg-aiguide empowers AI agents to produce more robust, performant, and maintainable database schemas and queries. The project supports an extension ecosystem starting with TimescaleDB and plans to expand further. It can be used as a public MCP server accessible to any AI coding agent or as a Claude Code plugin optimized for Claude's native skill support. The tool significantly improves schema generation by increasing constraints and indexes, incorporating modern PostgreSQL 17 recommended patterns, and using advanced features like GENERATED ALWAYS AS IDENTITY and NULLS NOT DISTINCT. This results in cleaner naming conventions and better documentation. pg-aiguide is easy to integrate with various AI coding environments through simple MCP server configuration or plugin installation commands. It supports multiple popular development environments and tools such as Cursor, VS Code, Visual Studio, Gemini CLI, and more, providing one-click installs and manual configuration options. The project is ideal for developers and AI tool users who want to leverage AI for PostgreSQL database design and coding while ensuring adherence to best practices and up-to-date PostgreSQL features. It offers example prompts for generating simple to complex schemas, making it a practical assistant for database schema design and query generation tasks. Keywords: MCP server, Claude plugin, PostgreSQL, AI coding tools, semantic search, Postgres best practices, schema generation, constraints, indexes, modern PostgreSQL features, TimescaleDB, AI agents, database schema, AI assistant, version-aware documentation, AI-optimized skills, public MCP server, Claude Code plugin, AI-generated code improvement, database design, AI integration, Cursor, VS Code, Visual Studio, Gemini CLI.
https://github.com/timescale/pg-aiguide
Also in Databases
t8y2/dbx
DBX is a lightweight, cross-platform database client supporting over 70 databases, featuring a built-in AI assistant, MCP Server, and available as desktop, Docker, or CLI.
Canner/WrenAI
Open-source generative BI engine that exposes governed text-to-SQL, a semantic layer and dashboard generation to AI agents through an MCP server and CLI across more than twenty data sources.
googleapis/mcp-toolbox
MCP Toolbox for Databases is an open-source Model Context Protocol (MCP) server that connects AI agents, IDEs, and applications directly to enterprise databases, offering both pre-built and custom ...
makenotion/notion-mcp-server
The Notion MCP Server is an official MCP server implementation that enables secure, programmatic interaction with Notion content through MCP commands, optimized for AI agents and supporting multiple deployment options.
bytebase/dbhub
DBHub is a universal database gateway implementing the Model Context Protocol (MCP) server interface, enabling MCP clients to connect to and explore multiple database systems including MySQL, PostgreSQL, Oracle, SQL Server, MariaDB, and SQLite.
crystaldba/postgres-mcp
Postgres MCP Pro is an open-source Model Context Protocol server for PostgreSQL that provides advanced database health monitoring, index tuning, query plan analysis, and safe SQL execution to support AI agents and developers throughout the application lifecycle.
supabase-community/supabase-mcp
Supabase MCP Server connects Supabase projects to AI assistants using the Model Context Protocol, enabling LLMs to manage and query Supabase resources.