dbt-mcp vs pg-aiguide
Side-by-side comparison to help you pick between these two MCP servers.
dbt-mcp by dbt-labs | pg-aiguide by timescale | |
|---|---|---|
| Stars | ★ 562 | ★ 1,729 |
| 30d uses | — | — |
| Score | 53 | 55 |
| Official | — | — |
| Categories | DatabaseDeveloper ToolsAI / LLM Tools | DatabaseDeveloper ToolsAI / LLM Tools |
| Language | Python | Python |
| Last commit | this month | this month |
dbt-mcp · Summary
A comprehensive MCP server for dbt Core, Fusion, and Platform, providing SQL, semantic layer, and dbt CLI tools.
pg-aiguide · Summary
MCP server providing PostgreSQL expertise, semantic search, and best practices for AI coding tools.
dbt-mcp · Use cases
- AI-powered data analysis and SQL generation in dbt projects
- Automating dbt project documentation and model lineage analysis
- Integrating dbt with AI agents for automated data modeling and testing
pg-aiguide · Use cases
- Improving PostgreSQL code generation in AI coding assistants
- Providing semantic search for PostgreSQL documentation
- Implementing best practices for database schema design
dbt-mcp · Install
Installation
Claude Desktop
Add to your Claude Desktop configuration:
{
"mcpServers": {
"dbt": {
"command": "npx",
"args": ["@dbt-labs/dbt-mcp"],
"env": {
"DBT_PROJECT_DIR": "/path/to/your/dbt/project"
}
}
}
}Other MCP clients
Use the experimental MCP bundle (dbt-mcp.mcpb) available in the latest release assets. Follow the [mcpb CLI](https://github.com/modelcontextprotocol/mcpb) documentation to install or inspect the bundle.
npm install -g @modelcontextprotocol/mcpb
mcpb install https://github.com/dbt-labs/dbt-mcp/releases/download/vX.X.X/dbt-mcp.mcpbpg-aiguide · Install
Installation Options
**As an MCP Server:** Add the public MCP server to your client configuration:
{
"mcpServers": {
"pg-aiguide": {
"url": "https://mcp.tigerdata.com/docs"
}
}
}**As Claude Plugin:**
claude plugin marketplace add timescale/pg-aiguide
claude plugin install pg@aiguide**Using npx skills:**
npx skills add timescale/pg-aiguide --skill postgres