{"data":{"slug":"duckdb","name":"DuckDB","tagline":"In-process OLAP database","category":"databases","categoryName":"Databases","url":"https://duckdb.org","github":"https://github.com/duckdb/duckdb","pricing":"open-source","hook":"DuckDB is SQLite for analytics—fast, embedded, and serverless.","whatsGood":"Analytics queries run locally without a server. Parquet, CSV, and JSON import just works. The SQL dialect is comprehensive. Integration with Python and R is seamless.","theCatch":"Not for OLTP workloads—it is analytics-focused. Single-node limits apply. Less ecosystem than traditional databases.","verdict":"Local analytics that just works.","addedAt":"2026-08-19","featured":false,"domain":"Databases","subSpecialty":"Data","capabilities":[],"surfaces":["Self-host"],"ecosystem":["Multi-platform"],"licenseModel":"OSS/MIT","githubStars":40958},"related":[{"slug":"supabase","name":"Supabase","tagline":"Open-source Firebase alternative built on Postgres"},{"slug":"turso","name":"Turso","tagline":"SQLite at the edge with libSQL"},{"slug":"redis","name":"Redis","tagline":"The in-memory data store everyone uses"},{"slug":"upstash","name":"Upstash","tagline":"Serverless Redis and Kafka"},{"slug":"pinecone","name":"Pinecone","tagline":"Vector database for AI applications"}],"links":{"self":"/api/gems/duckdb","html":"/gems/duckdb","markdown":"/gems/duckdb.md","category":"/api/gems?category=databases","categoryPage":"/stacks/databases"}}