The agent harness performance optimization system. Skills, instincts, memory, security, and research-first development for Claude Code, Codex, Opencode, Cursor and beyond.
npx ecc-install --profile fullFair-code workflow automation platform with native AI capabilities. Combine visual building with custom code, self-host or cloud, 400+ integrations.
npx n8nAn open-source AI agent that brings the power of Gemini directly into your terminal.
npx @google/gemini-cliInstall curated PostgreSQL best-practice skills for your AI coding agent:
npx skills add timescale/pg-aiguide --skill postgres
Or pick individual skills interactively:
npx skills add timescale/pg-aiguide
Works with Claude Code, Cursor, Codex, Gemini CLI, VS Code, and 40+ other agents.
For even deeper PostgreSQL knowledge, also add the MCP server to give your agent semantic search over the official PostgreSQL, TimescaleDB, and PostGIS manuals.
For semantic search over PostgreSQL, TimescaleDB, and PostGIS documentation, add the public MCP server:
https://mcp.tigerdata.com/docs
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
Or it can be used as a Claude Code Plugin:
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
Supports Claude Code, Codex, Cursor, Windsurf, Mcp
Carries strong trust indicators from repository metadata
1642 GitHub stars recorded
search_docs
Unified search tool supporting semantic (vector similarity) and keyword (BM25) search across multiple documentation sources:
postgres - Official PostgreSQL manual, scoped by versiontiger - Tiger Data's documentation (TimescaleDB and ecosystem)postgis - PostGIS spatial extension documentationview_skill
Exposes curated, opinionated PostgreSQL best-practice skills used automatically by AI coding assistants.
These skills provide guidance on:
We welcome:
This repo serves as a claude code marketplace plugin. To install, run:
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide
This plugin uses the skills available in the skills directory as well as our
publicly available MCP server endpoint hosted by TigerData for searching PostgreSQL documentation.
Run the following to add the MCP server to codex:
codex mcp add --url "https://mcp.tigerdata.com/docs" pg-aiguide
One-click install:
Or add the following to .cursor/mcp.json
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}
Run the following to add the MCP server to Gemini CLI:
gemini mcp add -s user pg-aiguide "https://mcp.tigerdata.com/docs" -t http
Click the button to install:
Click the button to install:
Alternatively, run the following to add the MCP server to VS Code:
code --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'
Click the button to install:
Alternatively, run the following to add the MCP server to VS Code Insiders:
code-insiders --add-mcp '{"name":"pg-aiguide","type":"http","url":"https://mcp.tigerdata.com/docs"}'
Add the following to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"pg-aiguide": {
"serverUrl": "https://mcp.tigerdata.com/docs"
}
}
}
Once installed, pg-aiguide can answer Postgres questions or design schemas.
Simple schema example prompt
Create a Postgres table schema for storing usernames and unique email addresses.
Complex schema example prompt
You are a senior software engineer. You are given a task to generate a Postgres schema for an IoT device company. The devices collect environmental data on a factory floor. The data includes temperature, humidity, pressure, as the main data points as well as other measurements that vary from device to device. Each device has a unique id and a human-readable name. We want to record the time the data was collected as well. Analysis for recent data includes finding outliers and anomalies based on measurements, as well as analyzing the data of particular devices for ad-hoc analysis. Historical data analysis includes analyzing the history of data for one device or getting statistics for all devices over long periods of time.