Lexicon database

Lexicon & metadata database

A self-hosted database for storing items, attaching custom fields and files, linking records together and finding anything again later.

  • FastAPI
  • PostgreSQL
  • Vue 3
  • TypeScript
  • MCP
Category
Lexicon & metadata database
Scope
Database, API, Vue 3 web app, worker & MCP
Core stack
FastAPI, PostgreSQL JSONB, Vue 3

The problem

Lexicons, research archives and reference libraries rarely fit a fixed table. Spreadsheets get messy, note apps are weak at typed fields and filters, and plain folders cannot search across your metadata and PDFs at the same time.

Here, a new item only needs a title. You can add fields, templates, links and files whenever they become useful.

What we built

A self-hosted web app running on FastAPI, PostgreSQL JSONB and Vue 3, with a background worker for file indexing and nightly backups.

  • Custom fields and templates Store text, numbers, dates, lists, dropdowns, repeating groups and links to other items. Reusable templates add defaults, units and min/max checks.
  • Typed links between items Directed relations (such as cites or part of) stored by ID so renames never break them, with backlinks and a visual connection map.
  • Search across notes and files Full-text search and faceted filters covering titles, descriptions, metadata, tags and text extracted from uploaded PDF, Word, Markdown and CSV files.
  • History, backups and MCP Every edit is versioned with field-level restore. Whole libraries export as SHA-256 verified zip bundles, and an MCP endpoint connects to AI tools.

Why this stack

PostgreSQL JSONB gives us free-form fields alongside normal relational tables, transactions and fast search. The whole stack runs in Docker Compose, so your records and files stay on your own server.

Need a custom database or knowledge tool?

Tell us what kind of records you are wrangling and how your team searches them. We will tell you honestly what it would take to build cleanly.

hello@bigfriendlycompany.eu