PK
T

Tarka

v1.0.0

Most PostgreSQL tools feel like they were designed in 2005 and never revisited. Tarka is a fresh take — a modern, intuitive query tool built from scratch with AI deeply integrated into the workflow. Use Claude or GPT to write, explain, and optimize SQL without leaving the editor. Bring your own API keys, everything stays local.

Download

macOS

Universal binary (Apple Silicon + Intel) — 115 MB

Signed and notarized by Apple. Requires macOS 12 or later.

Features

AI assistance

  • -Natural language to SQL — describe what you want in English and get a query
  • -Refine existing queries with follow-up instructions
  • -AI-powered EXPLAIN ANALYZE interpretation with optimization suggestions and index recommendations
  • -Schema-aware — the AI understands your tables, columns, and relationships
  • -BYOK (bring your own key) — supports OpenAI and Anthropic, keys stored locally

Query editor

  • -Syntax highlighting, autocomplete, and real-time error detection
  • -Multi-tab interface with drag-and-drop reordering
  • -Execute full queries or selected text, cancel long-running queries
  • -SQL formatting and comment toggling
  • -Focus mode for distraction-free writing (Cmd+.)
  • -Clutter-free mode — toggle from the top right to hide the sidebar and chrome, giving the editor and results the full window

Results & export

  • -Sortable, searchable result table with pagination
  • -Export to CSV, JSON, SQL INSERT statements, or Markdown
  • -Copy cells, rows (as JSON or TSV), or extract entire columns
  • -Expandable cells for long values, timezone conversion for timestamps
  • -Smart type rendering — pretty-printed JSON, formatted numbers, clear NULL indicators

Schema browser & table inspector

  • -Browse tables, views, columns, indexes, constraints, and partitions
  • -Full table inspector with tabs for columns, indexes, constraints, DDL, dependencies, storage, and vacuum stats
  • -Clean, first-class UI for partitioned tables — view partition strategy, key columns, individual partitions with their ranges, and child table details at a glance
  • -Storage breakdown with visual chart — table vs index vs TOAST size
  • -Smart Lookup — reads your table's indexes and generates a point-lookup form with the right WHERE clause fields already filled in. Pick an index, enter values, and run an efficient query without writing SQL
  • -Fuzzy search across all tables and views

Query plan visualization

  • -EXPLAIN ANALYZE with four distinct views: a plain-language summary, an interactive flow diagram showing how data moves between nodes, a flame graph for spotting time-heavy operations, and a collapsible tree for drilling into specifics
  • -Node-level metrics — rows scanned vs planned, loop counts, cost estimates, actual timing, and buffer usage so you can see exactly where time is spent
  • -Join and scan type display, partition pruning detection, and automatic bottleneck highlighting

Connections

  • -Save multiple PostgreSQL connections with color tags (production, staging, dev)
  • -SSL/TLS support with certificate file selection (all modes including verify-full)
  • -SSH tunneling with password or key file authentication
  • -Connection testing, latency display, and drag-and-drop reordering
  • -Credentials stored in your system keychain, not in plaintext

History & templates

  • -Automatic query history with execution time, row counts, CRUD stats, and error logging
  • -Save queries as reusable templates, organized into folders
  • -Search and filter history by SQL content or connection

Keyboard-first design

  • -Cmd+Enter to execute, Cmd+I for AI, Cmd+T for new tab
  • -Cmd+1-9 to switch tabs, Cmd+F to format, Cmd+/ to comment
  • -Context menus throughout — right-click on schema items, result cells, and rows for quick actions

Appearance

  • -Multiple built-in themes with live preview
  • -Configurable editor font size
  • -Query safety features — auto-limit SELECTs and destructive query confirmation

macOS 12 or later required. Signed and notarized by Apple.