Storage

Databases

OLTP systems, indexes, transactions, replication and how operational data is born.

4 resources 2 types

Inside this category

It currently holds 3 resources: 2 references, 1 mcp server. Mapped to roadmap stage: Data Processing. Verification mix: 3 community — check each entry's evidence before adopting.

Where to start: PostgreSQL MCP Server (43.57) , DuckDB and Hugging Face: Querying Datasets Directly (29.36) , Importing Data using Java Table Functions (29.36)

MCP server 45 adequate

PostgreSQL MCP Server

Connects an agent to a Postgres database with a read-only query tool and schema introspection.

Details

beginner mcppostgres community

Reference 24 unproven

DuckDB and Hugging Face: Querying Datasets Directly

Hugging Face hosts hundreds of thousands of datasets, and DuckDB can read them directly, exactly where they are and without downloading anything, over the DuckDB `hf://` protocol.

Details

community

Reference 24 unproven

Importing Data using Java Table Functions

When the analytics screen running on our main operational database got too slow, we moved a year of data into DuckDB on the same server.

Details

community

Reference 28 adequate

PostgreSQL Documentation — Tutorial & Reference

PostgreSQL's official documentation: the tutorial, SQL reference, indexes, transactions and MVCC chapters. The semantics of transaction isolation and index behavior here are the ground truth for correctness arguments in pipeline source systems.

Details

postgressql community