Top AI Repos — open-source AI, indexed and scored
Top AI Repos tracks AI repositories on GitHub and answers two different questions about each one: is it moving right now, and would you bet a product on it.
Top AI Repos tracks AI repositories on GitHub and answers two different questions about each one: is it moving right now, and would you bet a product on it.
MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
| Date | Stars |
|---|---|
| 2026-07-31 | 1801 |
| 2026-08-05 | 1807 |
| 2026-08-06 | 1807 |
| 2026-08-13 | 1812 |
| 2026-08-18 | 1815 |
| 2026-08-19 | 1814 |
| 2026-08-21 | 1817 |
| 2026-08-22 | 1818 |
| 2026-08-24 | 1821 |
| 2026-08-26 | 1823 |
| 2026-08-27 | 1824 |
| 2026-08-28 | 1825 |
| 2026-08-31 | 1826 |
| 2026-09-01 | 1827 |
| 2026-09-02 | 1830 |
| 2026-09-03 | 1833 |
| 2026-09-05 | 1835 |
| 2026-09-06 | 1834 |
| 2026-09-07 | 1835 |
| 2026-09-10 | 1835 |
| 2026-09-14 | 1835 |
| 2026-09-15 | 1836 |
| 2026-09-16 | 1837 |
| 2026-09-17 | 1841 |
| 2026-09-18 | 1843 |
| 2026-09-19 | 1848 |
| 2026-09-20 | 1848 |
Today
— stars today
This week
+13 stars this week
This month
+31 stars this month
Momentum
88.0
growth rate 0.71%/day
# pg-aiguide
**AI-optimized PostgreSQL expertise for coding assistants**
pg-aiguide helps AI coding tools write dramatically better PostgreSQL code. It provides:
- **Semantic search** across the official PostgreSQL manual (version-aware)
- **AI-optimized “skills”** — curated, opinionated Postgres best practices used automatically by AI agents
- **Extension ecosystem docs**, starting with TimescaleDB, with more coming soon
Use it as:
- **Agent Skills** via `npx skills` — works with Claude Code, Cursor, Codex, Gemini CLI, and 40+ other agents
- a **public MCP server** that can be used with any AI coding agent, or
- a **Claude Code plugin** optimized for use with Claude's native skill support.
## ⭐ Why pg-aiguide?
AI coding tools often generate Postgres code that is:
- outdated
- missing constraints and indexes
- unaware of modern PG features
- inconsistent with real-world best practices
pg-aiguide fixes that by giving AI agents deep, versioned PostgreSQL knowledge and proven patterns.
### See the difference
https://github.com/user-attachments/assets/5a426381-09b5-4635-9050-f55422253a3d
<details>
<summary>Video Transcript </summary>
Prompt given to Claude Code:
> Please describe the schema you would create for an e-commerce website two times, first with the tiger mcp server disabled, then with the tiger mcp server enabled. For each time, write the schema to its own file in the current working directory. Then compare the two files and let me know which approach generated the better schema, using both qualitative and quantitative reasons. For this example, only use standard Postgres.
Result (summarized):
- **4× more constraints**
- **55% more indexes** (including partial/expression indexes)
- **PG17-recommended patterns**
- **Modern features** (`GENERATED ALWAYS AS IDENTITY`, `NULLS NOT DISTINCT`)
- **Cleaner naming & documentation**
Conclusion: _pg-aiguide produces more robust, performant, maintainable schemas._
</details>
## 🚀 Quickstart
### Agent Skills
Install curated PostgreSQL best-practice skills for your AI coding agent:
```bash
npx skills add timescale/pg-aiguide --skill postgres
```
Or pick individual skills interactively:
```bash
npx skills add timescale/pg-aiguide
```
Works with Claude Code, Cursor, Codex, Gemini CLI, VS Code, and [40+ other agents](https://agentskills.io).
For even deeper PostgreSQL knowledge, also add the [MCP server](#mcp-server) to give your agent semantic search over the official PostgreSQL, TimescaleDB, and PostGIS manuals.
### MCP Server
For semantic search over PostgreSQL, TimescaleDB, and PostGIS documentation, add the **public MCP server**:
[https://mcp.tigerdata.com/docs](https://mcp.tigerdata.com/docs)
<details>
<summary>Manual MCP configuration using JSON</summary>
```json
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
```
</details>
Or it can be used as a **Claude Code Plugin**:
```bash
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
```
#### Install by environment
[](https://cursor.com/en/install-mcp?name=pg-aiguide&config=eyJuYW1lIjoicGctYWlndWlkZSIsInR5cGUiOiJodHRwIiwidXJsIjoiaHR0cHM6Ly9tY3AudGlnZXJkYXRhLmNvbS9kb2NzIn0=)
[](https://vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D)
[](https://insiders.vscode.dev/redirect/mcp/install?name=pg-aiguide&config=%7B%22type%22%3A%22http%22%2C%22url%22%3A%22https%3A%2F%2Fmcp.tigerdata.com%2Fdocs%22%7D&quality=insiders)
[
64
Matthew Peveler · @ConductorAI
35
12
7
6
5
3
2
1
Darafei Praliaskouski · Georgia
1
1
1
Would you bet a product on this? Bounded 0–100 and slow moving.
matched fp:7a79c7a7f9f6355c, topic:mcp, topic:mcp-server, desc:mcp server