stoolap

Organize and query local structured data with embedded SQL and vector embeddings.

1|Updated Feb 9, 2026
One-click install
npx skills add https://github.com/peteknowsai/swain-agents --skill stoolap
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: stoolap
Source: https://github.com/peteknowsai/swain-agents/tree/main/sprite/skills/stoolap
Command: npx skills add https://github.com/peteknowsai/swain-agents --skill stoolap

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Local teams often need to store structured data locally with fast SQL-backed querying while also enabling semantic search over embeddings. Stoolap provides an embedded, file-based database that supports vector columns for similarity lookup, all on the local filesystem.

Core Features & Use Cases

  • Embedded SQL database stored on the local filesystem for predictable performance.
  • Support for vector embeddings and semantic search to retrieve relevant knowledge quickly.
  • Real-world uses include maintaining maintenance logs, tracking trips, and building a local knowledge base that can be queried with SQL and nearest-neighbor search.

Quick Start

Start Stoolap by pointing it at a local database path and begin creating tables as you ingest data.

Frequently Asked Questions about stoolap

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run semantic search over a local SQL database?

You can run semantic search over a local SQL database by using an embedded, file-based system that supports vector columns for nearest-neighbor similarity lookup directly on the local filesystem.

What is the best way to combine vector embeddings with structured data logs?

The best way to combine vector embeddings with structured data logs is storing them together in an embedded SQL database, enabling fast relational queries alongside semantic search for maintenance logs or operational records.

Do I need a separate server to query local knowledge bases with SQL and vector search?

No, you do not need a separate server to query local knowledge bases with SQL and vector search; an embedded database runs directly on the local filesystem using a specified file path for predictable performance.

How do I set up a local database for vector similarity search?

To set up a local database for vector similarity search, point the embedded SQL engine at a local filesystem path, then begin creating tables that include vector columns as you ingest your data.

When should I use an embedded SQL database instead of a remote server for local data management?

Use an embedded SQL database for local data management when you need predictable performance, file-based storage without server overhead, and native support for querying structured records alongside vector embeddings.