Skip to content
Back to search

agentable

Native macOS database client for people and their coding agents

Safety scan

A static text scan, not a guarantee. Select the badge to see what was scanned and every finding.

Checked today
Badge for your README
findsafeskills safety rating

Markdown

[![findsafeskills safety rating](/api/listings/subasioguz--agentable/badge.svg)](/listings/subasioguz--agentable)

HTML

<a href="/listings/subasioguz--agentable"><img src="/api/listings/subasioguz--agentable/badge.svg" alt="findsafeskills safety rating" /></a>

Install

i

What was scanned

The files the safety scan read, as written by the repository's author and shown as plain text. Lines with a finding are marked.

README.md · README · 190 lines
  1. <p align="center">
  2. <picture>
  3. <source media="(prefers-color-scheme: dark)" srcset="docs/brand/wordmark-dark.svg">
  4. <img src="docs/brand/wordmark.svg" alt="Agentable" width="320">
  5. </picture>
  6. </p>
  7. <p align="center">A native macOS database client for you and your coding agents.</p>
  8. ![Agentable: an orders table with an agent's proposed changes in place](docs/images/workspace-light.png)
  9. You browse, filter and edit data in the app. Your agents (Claude Code, Codex, Cursor and others)
  10. work with the same saved connections through a CLI or an MCP server. They never see your
  11. passwords, they only do what each connection allows, their changes to protected databases wait for
  12. your approval, and everything they run is logged.
  13. > Status: early development. The app, the CLI and the MCP server work with SQLite and PostgreSQL.
  14. > There is no signed download yet; build it from source (see Build below).
  15. > See [docs/PLAN.md](docs/PLAN.md) for what comes next.
  16. ## The app
  17. | Filters with value counts | Review & apply |
  18. |---|---|
  19. | ![Filter chips with a value picker](docs/images/filter-light.png) | ![Reviewing an agent's proposal](docs/images/review-light.png) |
  20. | **Advanced conditions** | **Dark theme** |
  21. | ![Condition rows with and/or groups](docs/images/advanced-light.png) | ![The workspace in the dark theme](docs/images/workspace-dark.png) |
  22. - **Connections**, grouped by environment. Paste a `postgres://` URL or pick a SQLite file; the
  23. password goes to Keychain. An SSH tunnel runs through your own OpenSSH, so `~/.ssh/config`,
  24. `ProxyJump`, your SSH agent and `known_hosts` work as in Terminal (keys only, no SSH passwords;
  25. unknown host keys are refused). TLS can check a CA file and send a client certificate.
  26. - **Schema rail** with row counts, and columns with their types, keys and references.
  27. - **The table**, in pages: the bar under it says which rows you see ("1,201–1,400 of ~1.2M rows"),
  28. ‹ › (⌘[ ⌘]) turn pages, and the page button jumps to a page, sets rows per page (10 to 1,000, or any
  29. number you type) and turns an estimated total into an exact count. Filters and sorts start again at page 1. Each table remembers its
  30. sort, column order, hidden columns and widths; "Reset layout" in Columns puts it back, and
  31. Settings picks whether tables open oldest or newest first.
  32. - **Search rows** across every column with ⌘F, without making a filter; **Go to anything** (⌘K)
  33. jumps to a table or another connection.
  34. - **Filters** as chips with a value picker that shows how many rows have each value. "Advanced"
  35. turns the same filters into condition rows with and/or groups, and "WHERE" takes plain SQL.
  36. - **Your edits wait.** Double-click a cell to change it, add a row with ⌘I or duplicate one.
  37. Changes wait in a list under the table, where you can undo any one of them (⌘Z steps back too).
  38. ⌘S saves them in one transaction; on production you see the SQL first. When agents have proposals
  39. waiting, your edits and their proposals go through Review & apply together. An edit is refused if
  40. its row is gone or the value you edited changed since you loaded it (decimals and timestamps are
  41. not compared, since they cannot be matched exactly).
  42. - **Row details and foreign keys.** Space opens the selected row at the side: long text wraps,
  43. JSON is indented, and a foreign key opens the row it points to, with a way back. "Referenced by"
  44. lists the tables that point at the row and how many of their rows do.
  45. - **SQL tab** next to Data and Structure: colored SQL with completion of tables, columns and
  46. keywords. ⌘↩ runs the statement under the cursor; reads run on your read-only session, writes
  47. get a trial run and wait with your other changes. Explain shows the plan. The side panel lists
  48. saved queries (`.sql` files) and what ran on the connection lately, by you and by agents.
  49. When an agent suggests a new version of a saved query, its lines show in the editor, tinted,
  50. with its note: Tab accepts (⌘Z undoes), Esc dismisses; nothing runs until you run it.
  51. **Ask** (⌘I) sends a request about the open query ("only paid orders", "why is it slow?") to
  52. your Claude Code, which works in the background with Agentable's tools only: a change comes back
  53. as a suggestion in the editor, an answer as text above it. See Privacy below.
  54. - **Structure.** The Structure tab lists columns, indexes and checks (on PostgreSQL also index
  55. sizes, how often they are used and the views that read each column). Add, rename or drop a
  56. column, change its type, default or whether it allows empty values, and add or drop indexes.
  57. Changes wait as DDL with your other edits and run in one transaction; on production you see each
  58. statement and what it locks first. SQLite only renames a saved column in place. A renamed column
  59. keeps its mask for agents. An agent's proposed index shows in the list with its reason.
  60. - **Copy and export.** Copy rows as CSV, JSON, SQL INSERT or Markdown, or save the selection, the
  61. filtered view or the whole table to a file.
  62. - **Agents in the same table.** Rows an agent wants to change are tinted orange with the new value
  63. in a dashed box, its cursor shows the column it last read, and the Session panel lists what each
  64. agent did today.
  65. - **First launch** offers to add Agentable's MCP server to Claude Code, Codex and Cursor; later,
  66. "Connect agents" on the Connections screen or in the settings menu does the same.
  67. - Light and dark themes. The interface is in English, German, Spanish, French, Italian, Brazilian
  68. Portuguese, Russian, Turkish, Japanese, Korean, and Simplified and Traditional Chinese; it follows
  69. your Mac's language, or pick one under Language in the settings menu.
  70. ## Connect your agents
  71. `agentable init` prints the setup for Claude Code, Codex and Cursor. Agents then get eight MCP tools:
  72. `connections`, `schema_search`, `describe`, `query`, `explain`, `propose_change`, `saved_queries`
  73. and `suggest_sql`. The last two let an agent read your saved queries on a connection it may use
  74. (not ones that mention a hidden table) and suggest a new version of one, or a new query, which
  75. shows in your SQL editor until you accept or dismiss it.
  76. ## How agents use it from a shell
  77. ```sh
  78. agentable tables shop
  79. agentable search shop email
  80. agentable describe shop customers
  81. agentable query shop "SELECT name, email FROM customers LIMIT 20"
  82. agentable propose shop "UPDATE orders SET status = 'refund_pending' WHERE id IN (1, 2)" --reason "charged twice"
  83. agentable queries shop charged-twice.sql
  84. agentable suggest shop charged-twice.sql "SELECT ..." --note "count only successful payments"
  85. ```
  86. Results come back as compact tab-separated text (or `--json`), marked as data rather than
  87. instructions. A refused request exits with status 2 and says why.
  88. ## What each connection allows
  89. | Access | Agents can |
  90. |---------|-------------------------------------------------------------------------|
  91. | off | not see the connection |
  92. | read | read schema and run read-only queries within row and time limits |
  93. | propose | read, and file changes that a person reviews with `agentable review` |
  94. | write | read and write directly (never on production) |
  95. Defaults follow the environment: production starts at read, staging at propose, local and dev at
  96. write. Tables can be hidden and columns masked per connection. Raising access, unhiding or unmasking,
  97. and approving a change all ask for Touch ID or your password, so an agent with a shell cannot do them.
  98. ## Your side
  99. ```sh
  100. agentable connections add shop ./shop.sqlite --env production
  101. agentable connections rules shop --hide api_keys --mask customers.email
  102. agentable connections agent-role acme # SQL for a SELECT-only agent role (PostgreSQL)
  103. agentable proposals
  104. agentable review p-1a2b3c --approve
  105. agentable log shop
  106. ```
  107. ## Privacy
  108. Agentable has no account, no telemetry, no analytics and no crash reporting. It connects only to
  109. the databases you add. Fonts ship inside the app, so it never fetches anything to draw itself.
  110. One exception, only when you use it: **Ask** in the SQL tab runs your own Claude Code on this Mac,
  111. in an empty temporary folder, with nothing but Agentable's MCP tools (no files, no shell, no other
  112. servers) and no permission to propose changes. Claude Code then sends your request, the saved
  113. query and what it reads through Agentable to Anthropic, as it always does, under your Claude
  114. account. Nothing starts until you press Send, and Stop or quitting the app ends it.
  115. What it keeps, all on your Mac:
  116. | What | Where |
  117. |------|-------|
  118. | Saved connections (no passwords) | `~/Library/Application Support/Agentable/connections.json` |
  119. | Passwords | your login Keychain |
  120. | Audit log: who ran which statement, when, how many rows (not the rows themselves), including what you run in the SQL tab | `~/Library/Application Support/Agentable/state.sqlite` |
  121. | Proposals, with up to 200 of the rows they would change so you can review them (masked columns stay masked) | the same `state.sqlite` |
  122. | Agents' suggestions for your saved queries: the query's text when they suggested, their text and note | the same `state.sqlite` |
  123. | Window preferences: theme, default order, each table's sort, column order, hidden columns and widths, last opened table, panels you opened or closed, the last export format, when you last used each connection | macOS user defaults |
  124. | Saved queries | `~/Library/Application Support/Agentable/queries/<connection>/*.sql` |
  125. | Exports | only the file you pick in the save dialog |
  126. `AGENTABLE_HOME` moves connections, the state database and saved queries somewhere else.
  127. **What agents read leaves your Mac through the agent.** Query results go to the agent you
  128. connected, and the agent sends them to its model provider. Agentable decides what the agent gets:
  129. hide tables, mask columns, give agents a SELECT-only database role, and keep production at read or
  130. propose. Those rules apply to every agent request, and every request is logged, including refused
  131. ones.
  132. **Setting up agents** (first launch) changes their configuration only when you click Connect:
  133. Claude Code and Codex through their own `mcp add` commands, Cursor by adding one entry to
  134. `~/.cursor/mcp.json` after saving a copy of the file next to it. Before that, the app only reads
  135. those files to show what is already connected.
  136. ## Security
  137. The safety model is in [docs/PLAN.md](docs/PLAN.md#safety-model). To report a vulnerability,
  138. see [SECURITY.md](SECURITY.md).
  139. ## Build
  140. Requires macOS 15 and Swift 6.
  141. ```sh
  142. swift build
  143. swift test
  144. .build/debug/agentable --help
  145. scripts/bundle-app.sh # .build/Agentable.app with the CLI and fonts inside
  146. scripts/snapshot.sh # renders every screen to PNG with a demo database
  147. ```
  148. `scripts/snapshot.sh` keeps everything in its output folder (`AGENTABLE_HOME` points there), so it
  149. never touches your own connections.
  150. ## Brand
  151. The mark, app icon, colors and voice are in [docs/BRAND.md](docs/BRAND.md) and `docs/brand/`.
  152. ## License
  153. Apache License 2.0. See [LICENSE](LICENSE) and [NOTICE](NOTICE). The bundled fonts, Instrument Sans
  154. and Spline Sans Mono, are under the SIL Open Font License 1.1; their licenses are next to them in
  155. `Sources/AgentableApp/Resources/Fonts`.

Ratings and comments

Sign in to rate this skill.

Sign in

Free to use. If it’s helped, pass it on.