# Ollama PostgreSQL Data Analysis

> Use this tool when you need to analyze data in PostgreSQL databases using natural language queries, and get AI-interpreted results without writing SQL code. It solves the problem of manual query writing, providing an interactive chat interface for data analysts, business users, and developers to extract insights quickly. The tool takes in natural language input and outputs schema-aware results, making it ideal for use cases where ease of use and speed of analysis are crucial.

Canonical page: https://skillsregistry.net/skills/robdodson-ollama-postgresql  
JSON: https://api.skillsregistry.net/v1/skills/robdodson-ollama-postgresql

## Description

This MCP implementation provides an interactive chat interface that combines Ollama's LLM capabilities with PostgreSQL database access. Built with TypeScript and leveraging the Model Context Protocol, it enables natural language querying of SQL databases. The system automatically generates SQL queries based on user input, executes them through a secure, read-only connection, and returns AI-interpreted results. Key features include schema-aware responses and support for the qwen2.5-coder:7b-instruct model. This implementation is particularly useful for data analysts, business users, and developers who need to quickly extract insights from PostgreSQL databases without writing SQL queries manually.

## Trust

- **Trust score (0–1):** 0.50
- **Verification tier:** unverified

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-06-11

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/robdodson-ollama-postgresql)
- **Repository:** <https://github.com/robdodson/ollama-mcp-db>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "robdodson-ollama-postgresql"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/robdodson-ollama-postgresql` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/robdodson-ollama-postgresql/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt