The Open Source Drop #1: Agent sandboxes, semantic diffs, and a database TUI you'll actually enjoy
Welcome to The Open Source Drop, a free, no-BS look at open source tools worth knowing about. Every issue: a few tools we've actually researched, with honest analysis of what they do well and where they fall short. No sponsored picks. No hype.
an open source, extensible AI agent that goes beyond code suggestions - install, execute, edit, and test with any LLM
The Lens
Goose is a local AI agent with full access to your development environment: it writes code, runs commands, and drives your tools using whatever LLM you point it at. Block (the company behind Square and Cash App) built it, then donated it to the Linux Foundation's Agentic AI Foundation, which makes it one of the few coding agents with vendor-neutral governance instead of a single company's roadmap. Apache 2.0, free. Extensibility is the differentiator. Goose extends through MCP servers, so the same connectors that work with other agents plug in here: Kubernetes, AWS, CI pipelines, whatever your workflow touches. It runs as a CLI or desktop app, and releases land steadily, mostly provider integrations and protocol work, plus a patched command-execution advisory in its review feature earlier this summer. Use it if you want an open, vendor-neutral agent you can point at any model, including local ones through Ollama. Quality tracks the model: with a frontier model it's impressive, with small local models it struggles on complex tasks. The catch: giving an agent full terminal access is powerful and risky, so review what it runs, especially destructive commands. And model API costs are the real price. Expect $30-100/mo for daily use unless you go local.
Sandboxes for every agent: embeddable, stateful, with snapshots and hardware isolation.
The Lens
Boxlite gives you lightweight sandboxes. Each sandbox is a stateful micro-VM with hardware isolation, snapshots, and an API to control it. Picture giving every AI agent its own disposable computer. The project is open source under Apache 2.0 and self-hosting is free. It's early but growing fast. The 'agent sandboxing' space is heating up as AI agents get more autonomous and need safer execution environments. The catch: this is emerging technology. The documentation and ecosystem are still maturing. Running Firecracker-based micro-VMs requires Linux with KVM support. No macOS, no Windows natively. And the question of whether you need full VM isolation versus Docker containers depends on your threat model. For most use cases, Docker is simpler. Boxlite is for when you can't trust the code being executed.
Semantic version control CLI: entity-level diff, blame, graph, and impact analysis for code across 21 languages.
The Lens
Git diffs tell you which lines changed, not which functions did. Sem fixes that. Instead of line-by-line diffs, it gives you entity-level diffs: which functions changed, which classes were renamed, which dependencies shifted. Consider it version control that understands code structure, not just text. It supports 21 languages, runs as a CLI, and adds blame, graph, and impact analysis on top of the structural diff. The impact analysis is the real selling point: change a function and sem tells you what else in your codebase is affected. Written in Rust, Apache 2.0, fully free. No paid tier, no cloud, no account. Install the CLI and go. The catch: nascent stage. The concept is excellent but the ecosystem is tiny. If your language isn't in the 21 supported, you're out of luck. And at this star count, expect rough edges and sparse docs.
A user-friendly TUI for SQL databases. Supports SQL Server, MySQL, PostgreSQL, SQLite, and more.
The Lens
sqlit is a database client that runs in your terminal. Connect to SQL Server, MySQL, Postgres, SQLite, or Turso, browse tables, run queries, and read results in a formatted grid, all from the keyboard. No browser, no Electron shell, no login. MIT licensed and written in Python. Install is a pip command and you are connected. One unified interface across every backend it supports is the actual selling point, because moving between a Postgres project and a SQL Server project stops meaning moving between tools. It is under active development, with releases landing steadily through 2026. Completely free, with no paid tier and no hosted version. Solo: excellent for quick checks without waiting for a heavy GUI to load. Small teams: good for developers who live in the terminal and want data in front of them fast. Medium and large: this is a personal productivity tool rather than a team platform, so shared database management still wants dbeaver/dbeaver or something web-based with access control. The catch is that it is early and thin next to the mature tools. No saved queries, no ER diagrams, no export wizards. It is a browser, not a workbench. It will not replace DataGrip or DBeaver for schema work, but for the twenty times a day you just need to look at a table, it opens instantly and gets out of the way.
Get the next issue in your inbox
Free. No spam. Unsubscribe anytime.