Open Source Gems

Open source tools that are useful beyond code: drawing, design, data publishing, dashboards, and internal workflows.

This topic collects open source tools that help small teams think, publish, or operate without immediately buying a platform. A good open-source alternative is not just cheaper; it gives the team a clearer exit path, inspectable data, and enough maintenance signal to trust it in a real workflow.

Best for

  • Builders who want useful tools they can inspect, self-host, or extend.
  • Teams replacing heavyweight SaaS with focused open workflows.

How to use this lane

  • Check the hosted demo first, then inspect repo activity and export paths.
  • Favor tools that solve one workflow before expanding the stack.

Selection criteria

  • The project has practical non-code value for real workflows.
  • Source, licensing, and maintenance signals are easy to verify.

Common pitfalls

  • Choosing an open project only because it is free, not because it fits.
  • Ignoring export, backup, and maintenance requirements.

Why these gems

ExcalidrawA low-friction whiteboard that works for sketches and architecture notes.DatasetteMakes small public datasets browseable and publishable.MetabaseUseful when a team needs dashboards without starting from code.Datasette LiteA no-install bridge between raw data files and a shareable inspection workflow.MermaidKeeps architecture and process diagrams close to the Markdown or docs that explain them.

Related rabbit holes

Sketch and Publish an Open WorkflowLeave with one rough sketch, one prototype direction, and one way to publish supporting data.Evaluate an Open Source Alternative Before SwitchingLeave with one candidate tool, one exit-path note, and one risk decision for a small team.

Browse by intent

Learn3Make6Research2Design2Developer6

Featured gems

All gems in this topic

Learn · Make · Design · DeveloperExcalidrawAn open source whiteboard for sketchy diagrams, quick architecture maps, and collaborative visual thinking.Make · Design · DeveloperPenpotAn open source design and prototyping platform built around web standards and team collaboration.Make · Research · DeveloperDatasetteAn open source tool for publishing, exploring, and sharing SQLite-backed data as a small web app.Make · Research · DeveloperMetabaseAn open source business intelligence tool for asking questions, building dashboards, and sharing data views.Learn · Make · DeveloperNocoDBAn open source no-code database interface that turns databases into collaborative spreadsheet-like tables.Make · Learn · DeveloperMermaidA text-based diagramming library for flowcharts, sequence diagrams, state diagrams, and documentation-friendly charts.

Learn

3 gems

ExcalidrawOpen Excalidraw and start here: Draw one messy version first, then group related objects.NocoDBOpen NocoDB and start here: Start with one table and define a few useful views.MermaidOpen the Mermaid Live Editor and modify one example diagram before reading the full syntax guide.

Make

6 gems

ExcalidrawOpen Excalidraw and start here: Draw one messy version first, then group related objects.PenpotOpen Penpot and start here: Duplicate a simple template and inspect layout constraints.DatasetteOpen Datasette and start here: Put one cleaned CSV into SQLite.MetabaseOpen Metabase and start here: Connect a small read-only database first.NocoDBOpen NocoDB and start here: Start with one table and define a few useful views.MermaidOpen the Mermaid Live Editor and modify one example diagram before reading the full syntax guide.

Research

2 gems

DatasetteOpen Datasette and start here: Put one cleaned CSV into SQLite.MetabaseOpen Metabase and start here: Connect a small read-only database first.

Design

2 gems

ExcalidrawOpen Excalidraw and start here: Draw one messy version first, then group related objects.PenpotOpen Penpot and start here: Duplicate a simple template and inspect layout constraints.

Developer

6 gems

ExcalidrawOpen Excalidraw and start here: Draw one messy version first, then group related objects.PenpotOpen Penpot and start here: Duplicate a simple template and inspect layout constraints.DatasetteOpen Datasette and start here: Put one cleaned CSV into SQLite.MetabaseOpen Metabase and start here: Connect a small read-only database first.NocoDBOpen NocoDB and start here: Start with one table and define a few useful views.MermaidOpen the Mermaid Live Editor and modify one example diagram before reading the full syntax guide.