Plain-text notes hold up fine until the day you need to answer “which of these 400 book notes are unread” or “what did the team decide about the Q2 kickoff.” Suddenly the pile of markdown files that felt so freeing turns into a search-and-scroll job that nobody wants to do. That gap between capture and retrieval is what the best apps for note databases exist to close, and after the arrival of Obsidian Bases in 2026 the desktop shortlist looks different than it did a year ago.
We looked at eight tools that let you build filterable, view-switching databases inside your notes on Windows, macOS, and Linux: some are local-first and free, some are cloud-first and paid, one is fully open source and self-hostable, and one started life as a spreadsheet-document hybrid. Every pick below is actively maintained in 2026 and gets real work done today.
What to look for in a note-database app
Not every note app that adds a table view counts as a real note-database tool. A few checks before committing:
Query surface. Can you filter by tag, date, folder, or arbitrary property? Is there a formula or expression language, or just sort and filter?
View types. Table is the baseline. Gallery, board (kanban), calendar, and grouped views are what make a note database more useful than a spreadsheet.
Data location. Local plain-text files stay portable and back up trivially. Proprietary cloud storage means fewer footguns but real lock-in risk.
Sync and collaboration. Free peer-to-peer, paid subscription, self-hosted server, or none at all. Match the pick to how you actually work.
Extensibility. A plugin ecosystem, scripting layer, or API lets you cover queries the base tool cannot express.
Export path. If the tool shuts down or triples its price, you should be able to leave with data in a readable format.
Quick comparison
| App | Best for | Platforms | Free plan | Starting price/mo |
|---|---|---|---|---|
| Obsidian | Local-first vaults with Bases | Windows, macOS, Linux | Full features, no limits | $4 (Sync, annual) |
| AppFlowy | Open-source Notion swap | Windows, macOS, Linux | Full features, self-host or solo cloud | $10 (Pro, annual) |
| Logseq | Outliner-native databases | Windows, macOS, Linux | Full features, no limits | Free (self-host sync) |
| Anytype | Encrypted local objects | Windows, macOS, Linux | 1 GB storage, all features | ~$10 (Any Pro) |
| Notion | Team-shared databases | Windows, macOS, Web (Linux via browser) | Solo unlimited blocks | $10 (Plus, annual) |
| Capacities | Object-based notes | Windows, macOS, Web | Core features, limited AI | $10 (Pro, annual) |
| Tana | AI supertags and live searches | Windows, macOS, Web | Limited nodes and AI credits | $10 (Plus) |
| Coda | Formula-driven documents | Windows, macOS, Web | Unlimited docs, small row limits | $10 (Pro, annual) |
The apps
1. Obsidian – Best for local-first vaults that finally got real databases
Obsidian’s core product is a folder of markdown files, and in 2026 it added Bases, a first-party database layer that turns any set of notes into a filterable, sortable, groupable view without a plugin. Combined with the older Dataview plugin, you can express queries like “unread books tagged #history published after 2020” and pin the result to a note. Every core feature, including Bases, is free forever.
Where it falls short: No built-in real-time collaboration. Sync across devices costs extra ($4/user/month billed annually) unless you self-host with Syncthing or a git repo. Bases is newer than Dataview and does not yet cover every corner case that community plugins do.
Pricing:
- Free: full app, all core features, Bases, community plugins, unlimited local vaults.
- Paid: Sync $4/user/month annual, Publish $8/site/month annual, optional $50/user/year commercial license.
Platforms: Windows, macOS, Linux, iOS, Android.
Download: obsidian.md · Community plugins
Bottom line: The default pick for anyone who wants their notes AND their databases to live as plain files on disk. Skip if you need multi-user editing on the same document.
2. AppFlowy – Best free open-source alternative
AppFlowy is the closest open-source clone of Notion’s grid, board, and calendar views, built in Rust and Flutter, licensed AGPL-3.0. The desktop app runs offline immediately after install with no account required, and the cloud sync tier is optional. Self-hosting is free and documented.
Where it falls short: Formula support and third-party integrations are thinner than Notion’s. Some polish gaps around drag-and-drop and rich embeds compared to the incumbents.
Pricing:
- Free: self-hosted install with no seat cap, or solo cloud with up to 2 members and 5 GB storage.
- Paid: AppFlowy Pro $10/user/month billed annually for unlimited storage and higher AI limits.
Platforms: Windows, macOS, Linux, iOS, Android, Web.
Download: appflowy.io · GitHub releases
Bottom line: The best pick if you want Notion’s shape without the lock-in or the seat pricing. Skip if you need a large plugin marketplace.
3. Logseq – Best outliner-first note database
Logseq treats every bullet as an addressable block, which makes its query engine unusually powerful for a free tool. The {{query}} and Datalog interfaces can pull matching blocks from anywhere in the graph and render them inline as tables or lists. The new database-backed version (Logseq DB) landed after the long refactor and coexists with the classic file-based build.
Where it falls short: The DB split confused a lot of long-time users, and mobile lags Obsidian’s polish. Real-time collab is still limited, and paid sync is currently in beta.
Pricing:
- Free: full desktop and mobile app, all query features, both file-based and DB builds.
- Paid: Logseq Sync (beta) at a modest monthly fee once it ships general availability.
Platforms: Windows, macOS, Linux, iOS, Android.
Download: logseq.com · GitHub releases
Bottom line: The right pick if you think in bullets and want the strongest free query language. Skip if you prefer document-shaped notes over outlines.
4. Anytype – Best privacy-first local database
Anytype models notes as typed objects (books, people, meetings) with schemas you define, all stored encrypted on your device with peer-to-peer sync between your own machines. No central server holds your data. Views include grid, gallery, board, calendar, and graph, and every object can hold structured properties and relations.
Where it falls short: The object model has a learning curve, and importing existing markdown vaults is finicky. Collaboration relies on invited “spaces” and is less mature than Notion’s.
Pricing:
- Free: full app, 1 GB syncing across your own devices, unlimited local storage.
- Paid: Any Pro at roughly $10/month (or ~$99/year) for larger sync quotas and priority support.
Platforms: Windows, macOS, Linux, iOS, Android.
Download: anytype.io · GitHub releases
Bottom line: The right choice if end-to-end encryption is non-negotiable and you like a strict schema. Skip if you want to keep your notes as plain markdown files.
5. Notion – Best for shared team databases
Notion is still the reference point for what a note-database looks like in a browser, and the 2026 free plan gives solo users unlimited blocks plus the full database engine. Views include table, board, calendar, timeline, gallery, and list, and formulas remain the most approachable of any tool on this list. Sharing a database with a client or teammate is a two-click operation.
Where it falls short: No native Linux app (browser or wrapper only). Free plan drops to 1,000 blocks total once a second workspace member joins. Everything lives on Notion’s servers with no local export beyond markdown or CSV.
Pricing:
- Free: solo unlimited blocks, 7-day page history, 5 MB file cap, basic databases and calendar.
- Paid: Plus $10/user/month annual, Business $20/user/month annual, Enterprise custom.
Platforms: Windows, macOS, iOS, Android, Web (Linux via browser).
Download: notion.com · Web app
Bottom line: Still the fastest way to spin up a shared database with a client or a small team. Skip if you want your data on disk or you work primarily on Linux.
6. Capacities – Best object-based note structure
Capacities lands between Notion and Anytype in philosophy: everything is a typed object (page, book, person, meeting) but it lives in the cloud with a polished, consistent desktop and web UI. The database views understand the type system, so a Books gallery inherently knows what a Book is and how to display one. The daily-note home screen keeps a Logseq-ish workflow intact.
Where it falls short: No native Linux app (web only). No self-host option and no plain-text export path beyond markdown snapshots. Offline support is workable but not seamless.
Pricing:
- Free: core object types, all views, basic sync, limited AI credits.
- Paid: Pro at $10/month billed annually for expanded AI, custom object types, and higher upload limits.
Platforms: Windows, macOS, iOS, Web (Linux via browser).
Download: capacities.io · Web app
Bottom line: The right pick for people who liked Logseq’s daily-note home but want a smoother, more opinionated UI. Skip if local plain-text storage matters to you.
7. Tana – Best AI-native power user tool
Tana is what you get when an outliner, a database, and an AI assistant share the same file format. Every node can be tagged with a Supertag that carries schema, and “live searches” render dynamic dashboards that update whenever matching nodes appear anywhere in the graph. Voice capture, AI chat, and automated task lists are built in, not bolted on.
Where it falls short: Steep learning curve; the reward for climbing it is high, but the first week is rough. No native Linux app, no offline mode of note, and no local export beyond markdown.
Pricing:
- Free: limited nodes and AI credits, single workspace.
- Paid: Plus at $10/month for AI chat, voice transcription, and unlimited Supertags. Pro at $18/month adds templates and API access.
Platforms: Windows, macOS, iOS, Android, Web (Linux via browser).
Bottom line: The right pick if you want AI baked into how you query your notes, not sitting in a side panel. Skip if you dislike outliners or need offline-first storage.
8. Coda – Best formula-driven document (unconventional pick)
Coda started as a spreadsheet-document mashup, and its formula language is still the most powerful on this list. Any Coda doc can hold tables that reference each other, and any table can display as a card, calendar, timeline, or grouped list inside the same page. Buttons and Packs let you trigger actions like sending Slack messages or updating rows from other Coda docs.
Where it falls short: No native Linux app. Free plan caps rows and objects per doc; hitting the cap is a common source of upgrade pressure. Fewer note-taking niceties (like backlinks) than the others on this list.
Pricing:
- Free: unlimited docs, small per-doc row limits, up to 3 editors per doc.
- Paid: Pro $10/month annual, Team $30/month annual, Enterprise custom.
Platforms: Windows, macOS, iOS, Android, Web (Linux via browser).
Bottom line: The right pick when your “notes” are really spreadsheets in disguise and you want formulas as first-class citizens. Skip if you want a real note-taking flow.
How to pick the right one
If you want plain-text on disk and the most future-proof format: Obsidian. Bases plus community plugins covers 95% of what everyone else does, and if it shuts down tomorrow your notes are still readable in any text editor.
If you want free and open-source you can self-host: AppFlowy for the Notion shape, Logseq for the outliner shape.
If encryption and local storage matter more than anything: Anytype. Peer-to-peer sync between your own devices with no third party holding the data.
If your team already lives in the browser and you need to share databases with clients: Notion. Nothing else onboards a non-technical teammate faster.
If you want opinionated structure without wiring up templates yourself: Capacities for the polished object model, Tana if you want AI as the default query interface.
If your “notes” are really trackers and dashboards: Coda. The formula language will outrun every other pick on this list.
If you tried Notion and hated the block editor: Anytype or Obsidian give you fundamentally different shapes for the same problem.
FAQ
What is the best free app for building databases inside notes?
Obsidian and Logseq are both free forever with no feature caps and both include real query languages. Obsidian’s Bases feature (2026) is the easier on-ramp; Logseq’s outliner-first block queries are more powerful once you learn Datalog. AppFlowy is a third strong free option if you want the Notion-style grid and board UI open-source and self-hostable.
Does Obsidian have databases now?
Yes. Obsidian shipped Bases in 2026 as a first-party feature, which turns any set of notes into a filterable, sortable, groupable view (table, board, or gallery) without a plugin. The older Dataview community plugin still offers a more expressive query language, and both can be used in the same vault.
Is Notion still worth paying for in 2026?
For solo users, no: the free plan gives unlimited blocks and the full database engine. For small teams the Plus plan at $10/user/month annual is the smoothest way to share databases with clients or colleagues, especially non-technical ones. If you need a native Linux app or plain-text storage, look at Obsidian or AppFlowy instead.
Can I self-host a Notion alternative for free?
AppFlowy is the most complete free self-host option in 2026, licensed AGPL-3.0, with a documented Docker deployment path. Obsidian is not a server product, but you can pair it with Syncthing, a private git repo, or a WebDAV server for zero-cost cross-device sync. Anytype uses peer-to-peer sync between your own devices with no server involved.
What is the difference between Tana and Anytype?
Tana is cloud-first, outliner-native, and AI-heavy: Supertags define schema, live searches render dashboards, and the assistant is baked into daily use. Anytype is local-first, object-based, and privacy-focused: everything is encrypted on-device with peer-to-peer sync, and there is no central server. Pick Tana for AI-assisted querying, Anytype for zero-trust storage.
Which of these apps runs on Linux natively?
Obsidian, AppFlowy, Logseq, and Anytype ship native Linux desktop apps in 2026. Notion, Capacities, Tana, and Coda do not, though all four work in a Linux browser and some users wrap them with tools like Nativefier for a desktop-like feel.
