Practical Open Source Projects
Practical Open Source Projects
sql‑tap: Real‑Time SQL Watching with TUI and Web UI
Discover sql‑tap, a lightweight Go‑based proxy that lets you monitor PostgreSQL, MySQL and TiDB traffic in real time without touching your application code. Learn how to install it via Homebrew, Go, Docker or source, launch the terminal UI or web dashboard, and use built‑in N+1 query detection, EXPLAIN support, and query analytics. Perfect for developers and DBAs looking to spot slow queries, debug transactions and improve performance. Get a step‑by‑step guide and best‑practice tips in this comprehensive walkthrough.
Create Web Slides with Claude Code's Frontend Slides
Step into the future of web presentations with Claude Code's Frontend Slides – a zero‑dependency skill that lets you transform ideas and PowerPoint decks into sleek, responsive HTML slides. From a simple CLI command to a gallery of visual style previews, the project empowers designers and developers alike to build, customize, and host slides without a framework. Learn how to install, convert .pptx files, and explore the curated style presets that keep your decks unique and engaging. Whether you’re running a startup pitch or crafting a lecture, this open‑source tool delivers production‑grade slides right within your browser.
TinyClaw: Multi-Agent AI Teams for Discord, WhatsApp, Telegram
TinyClaw is a lightweight, MIT‑licensed framework that lets you run multiple AI agents that work together across Discord, WhatsApp, and Telegram. With a single command‑line interface you can spin up teams, configure unique roles, and watch live conversations through a TUI dashboard. The repository includes a full README, installation scripts, channel guides, and advanced features like heartbeat monitoring and agent pairing. Whether you’re a developer looking for a plug‑and‑play chatbot, or a researcher wanting to experiment with collaboration among AI assistants, TinyClaw brings the power of multi‑agent coordination right to your terminal.
Claude Supermemory V2: Persistent Memory Plugin for Claude Code
Claude Supermemory V2 is a free, open‑source add‑on that gives Claude Code persistent memory across sessions and teams. With auto‑capture, project‑specific settings, and a simple install process, developers can quickly turn Claude into a smart, memory‑aware assistant that learns from past work. This article walks through installation, configuration, core commands, and tips for maximizing its benefits in real‑world projects.
FareBot: Open Source NFC Transit Reader for Android, iOS, Web
FareBot is a free, Kotlin‑Multiplatform app that lets you read smart cards from public transit systems worldwide using your NFC‑enabled phone, mac OS card reader, or web browser. Supporting dozens of cards—from Suica, Octopus, and MTR to T‑Union and BTP—to a fully documented code base, FareBot is ideal for developers wanting to learn modern Kotlin tooling or contributors looking to add new systems. The project ships with a simple Makefile, dev‑container for Claude Code, and even experimental WebAssembly support, making it a one‑stop showcase of how open‑source can power real‑world NFC solutions.
LocalGPT: Run a Powerful AI Assistant Locally in Rust with Minimal Deps
LocalGPT brings a fully functional AI assistant to your machine without any cloud dependency or complex stack. Built entirely in Rust, it offers a single‑binary install, multiple LLM providers, persistent markdown memory, a versatile CLI, web UI, Telegram bot, and a built‑in security sandbox. Whether you want a research companion, a personal knowledge manager, or a low‑latency chatbot, LocalGPT has you covered. Follow our guide to install, configure, and extend this open‑source tool, and discover how its lightweight design empowers developers, researchers, and privacy advocates alike.
PicoClaw: Ultra‑Lightweight Go AI Assistant for <$10 Hardware
PicoClaw is a tiny, high‑speed AI assistant coded in Go that runs on a $10 board with less than 10 MB of memory. It boots in one second, supports RISC‑V, ARM, and x86, and can even turn an old Android phone into a smart assistant via Termux. With built‑in webhook support for Telegram, Discord, and more, PicoClaw turns a cheap SBC into a full‑featured agent without any proprietary token. This article walks through the repo’s key features, quick start, advanced deployment options, and security sandboxing, so developers can quickly prototype low‑cost AI solutions.
NanoClaw: Lightweight WhatsApp AI Assistant with Claude
NanoClaw brings a highly secure, fully containerized Claude-powered assistant right to your WhatsApp. This short article explains how the project keeps your data safe, how you can spin up agent swarms, and how you can tailor the bot with simple skill scripts—no micro‑services, no config files. Ready to replace Clawdbot with a codebase you understand in minutes? Read on to learn installation, customization, and future‑proof extensibility.
Anthropics Knowledge Work Plugins: AI for Role‑Specific Tasks
Discover how Anthropic’s open‑source Knowledge Work Plugins turn Claude into a role‑specific AI powerhouse. The repository bundles over a dozen plugins—ranging from product management to bio‑research—each wired to popular tools like Slack, Notion, and Snowflake. Learn how to install, customize, and extend these plugins right from Claude’s command line or through the Cowork marketplace. Whether you’re a developer, data scientist, or knowledge worker, explore how these markdown‑only, code‑free connectors can slash repetitive work and elevate collaboration. Start building or customizing your own plugins today and see how Claude can become the smartest member of your team.
Beautiful‑Mermaid: Ultra‑Fast, Fully‑Themeable Mermaid Diagram Renderer
Discover Beautiful‑Mermaid, a lightweight, TypeScript library that turns Mermaid syntax into stunning SVGs or terminal‑friendly ASCII art. Built by the Craft team, it’s 100 % DOM‑free, supports 5 diagram types, 15 ready‑made themes, and live CSS‑based theme switching. Whether you’re adding visual flowcharts to a web UI or rendering sequence diagrams in a CLI, Beautiful‑Mermaid offers blazing performance and full Shiki‑theme compatibility. Learn how to install, use, and customize it in this step‑by‑step article.