The best open-source Productivity Knowledge tools, curated: 10 in the registry, including Maintainer relicenses from MIT/LGPL to EUPL to close the SaaS loophole, airtable.js, gspread. Every tool is open-source; each entry lists license, self-hostability, and links.
Maintainer relicenses from MIT/LGPL to EUPL to close the SaaS loophole— news, 2026-09-06 Henri Bergius (NoFlo, Midgard) relicensed his projects from MIT/LGPL to the EUPL-1.2 — an OSI-approved, EU-backed copyleft whose obligations extend to software offered over a network, closing the "SaaS loophole". Relevant when selecting self-hostable tools: license class is a deliberate maker choice, and network-copyleft (EUPL/AGPL) affects hosted redistribution, not internal self-hosting.
airtable.js— tool, 2026-09-03 ~2223 stars; complements pyairtable; VENDOR (Airtable) official JavaScript client for the Airtable REST API (PAT/OAuth). ToS-clean and authoritative for Node/browser.
gspread— tool, 2026-09-03 ~7492 stars; complements google-api-python-client; Ergonomic wrapper over the official Google Sheets API (OAuth2 / service account). ToS-clean; the go-to Python Sheets client. Subject to Sheets API per-minute read/write quotas.; via GitHub cross-ref, ossinsight.io
notesmd-cli (Obsidian CLI Community)— tool, 2026-09-03 ~1568 stars; complements obsidian-git; Go CLI acting on LOCAL Obsidian vault markdown files (plus obsidian:// URIs) — no platform account, no ToS/ban risk (local files). Active; formerly named obsidian-cli. Finalist for local-KB automation.
notion-sdk-js— tool, 2026-09-03 ~5649 stars; complements notion-sdk-py, ultimate-notion; VENDOR (makenotion) official JavaScript/TypeScript SDK for the Notion API (integration token / OAuth). ToS-clean and authoritative for Node projects.
notion-sdk-py— tool, 2026-09-03 ~2174 stars; complements notion-sdk-js, ultimate-notion; Sync+async Python client mirroring the OFFICIAL Notion API (integration token / OAuth). ToS-clean; the de-facto Python SDK. Standard Notion API rate limit ~3 req/s per integration.; via GitHub cross-ref, ossinsight.io
Office365-REST-Python-Client— tool, 2026-09-03 ~1716 stars; complements msgraph-sdk-python; Python client for SharePoint REST + Microsoft Graph (OAuth2 / app registration, client-cert or secret). ToS-clean; the most complete community Python option for SharePoint/OneDrive/M365 file ops.
pyairtable— tool, 2026-09-03 ~892 stars; complements airtable.js; Python client for the OFFICIAL Airtable REST API (personal access token / OAuth). ToS-clean; de-facto Python SDK. Airtable API rate limit ~5 req/s per base.
OpenExecutive— tool, 2026-08-31 A self-hostable virtual executive advisory board: one executive voice backed by eight specialist agents (strategy, finance, HR, legal, ops, marketing, product, board comms), with RAG over your own company docs, episodic memory across sessions, and a follow-up scheduler. Ships Slack/email/Telegram/Discord/web/CLI.
Khoj— tool, 2026-08-31 A self-hostable AI 'second brain': chat with local or cloud LLMs over your own PDFs/Markdown/Notion/org-mode with semantic search and cited answers, build custom agents, and use it from the browser, Obsidian, Emacs, desktop, phone, or WhatsApp. Replaces several paid AI-assistant subscriptions.