# GetDot Database Skills

Agent Skills and MCP server for [GetDot Database](https://db.getdot.ai) — a fast analytical database for AI agents.

Compatible with Claude Code, GitHub Copilot, Cursor, Cline, and [18+ other AI agents](https://agentskills.io).

## What's Inside

### Agent Skill (`skills/`)

A [SKILL.md](skills/SKILL.md) following the [Agent Skills open standard](https://agentskills.io/specification). Gives AI agents the context to query GetDot Database: HTTP API, PostgreSQL wire, SQL dialect (DuckDB), data loading, time travel, and RBAC.

**Install:**

```bash
npx skills add zurferr/getdot-database-skills
```

### MCP Server

A single `query` tool that executes SQL via the GetDot HTTP API. Everything is SQL — schema discovery (`SHOW TABLES`, `DESCRIBE`), data loading (`read_csv_auto()`), time travel (`AT VERSION`), and more.

**Setup** — add to your `.mcp.json`:

```json
{
  "mcpServers": {
    "getdot-database": {
      "command": "npx",
      "args": ["-y", "github:zurferr/getdot-database-skills"],
      "env": {
        "GETDOT_API_TOKEN": "dot_yourorg_yourtoken"
      }
    }
  }
}
```

Get your token at [db.getdot.ai](https://db.getdot.ai) (sign in with GitHub, free tier included).

## Quick Start

Once connected, ask your AI agent:

- "Show me the tables in my database"
- "Import this CSV into a new table: https://example.com/data.csv"
- "What columns does the events table have?"
- "Give me a monthly count of events"

The agent will use SQL under the hood — no special API knowledge needed.

## Links

- [GetDot Database](https://db.getdot.ai)
- [Full docs (llms.txt)](https://db.getdot.ai/llms.txt)
- [Agent Skills Standard](https://agentskills.io/specification)
- [MCP Protocol](https://modelcontextprotocol.io)

## License

Apache-2.0