Manticore Search

active

by Manticore Software · since 2017 · also known as Manticore

Fast SQL-first search database, forked from Sphinx, with columnar storage and vector KNN.

search enginedocumentvectorcolumnar / olapdatabase engineopen source (copyleft)mature

Overview

Manticore Search forked from Sphinx 2.3 in 2017 and has since become a full search database: real-time tables, a MySQL-protocol SQL interface, an Elasticsearch-like JSON API, columnar storage, joins and HNSW vector search. It is noticeably lighter on resources than Elasticsearch and often faster for full-text and log-style queries on a single box. Replication is Galera-based and distribution across nodes is done with distributed tables. A good fit if you like SQL, want an open-source (GPL-3.0) engine, and do not need the Elastic ecosystem.

Strengths & trade-offs

Strengths

  • +Low memory footprint and fast full-text queries on modest hardware
  • +Talk to it with any MySQL client using SQL
  • +Columnar library for analytics-style filters and aggregations
  • +HNSW KNN vector search plus auto-embeddings
  • +Fully open source under GPL with no enterprise-only core

Trade-offs

  • −Sharding is manual via distributed tables
  • −Smaller community and integrations than Elasticsearch
  • −Elasticsearch API compatibility is partial
  • −Documentation can lag the rapid release cadence

Great for

  • +Site and product search with SQL
  • +Log search on a budget
  • +Replacing legacy Sphinx installs
  • +Hybrid keyword plus vector search

Think twice for

  • −Teams needing automatic elastic sharding
  • −Heavy reliance on Kibana-style tooling
  • −Transactional OLTP

Capabilities

Native or official first-party support · 10 of 25 tracked

✓Transactions
✓Joins
✓Secondary indexes
✓Full-text search
✓Vector search
✓Geospatial
✓JSON
✓Columnar storage
✓Durable persistence
✓Compression
–Change data capture
–Triggers
–Stored procedures
–Materialized views
–TTL / expiry
–Pub/Sub
–In-memory
–Encryption at rest
–Role-based access
–Time travel
–Branching
–Online schema changes
–Streaming ingest
–Offline sync
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Medium · ≤ 10 TB
Horizontal scaling
Manual
Multi-region
No
Transactions
Limited ACID
Consistency
Strong
Schema
Flexible
Architecture
Distributed, Multi primary, Client server
Query languages
SQL (SphinxQL dialect), JSON query API

Distributed tables fan queries out to shards you define; Galera-based synchronous replication for HA.

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

Ecosystem

compatible withMySQL
apis & protocolsMySQL wire protocol, HTTP/JSON
client languagesPython, PHP, JavaScript, Java, Go, TypeScript, Rust

Alternatives to Manticore Search

Compare all→
SphinxSearch Engine5.2

Veteran C++ full-text search server with SphinxQL, still shipping as Sphinx 3.

manticore-search vs sphinx →
ElasticsearchSearch Engine75.1

Lucene-based distributed search and analytics engine for text, vectors, logs and metrics.

manticore-search vs elasticsearch →
OpenSearchSearch Engine56.6

Apache-licensed, foundation-governed fork of Elasticsearch for search, vectors and observability.

manticore-search vs opensearch →
TypesenseSearch Engine28.8

In-memory, typo-tolerant search engine in C++ with vector, hybrid and conversational search.

manticore-search vs typesense →
MeilisearchSearch Engine32.3

Developer-friendly Rust search engine with typo tolerance and built-in hybrid semantic search.

manticore-search vs meilisearch →
QuickwitSearch Engine11.9

Cloud-native search engine on object storage for logs and traces, built on Tantivy.

manticore-search vs quickwit →

Manticore Search FAQ

What is Manticore Search?

Manticore Search is a search engine database by Manticore Software, first released in 2017. Manticore Search forked from Sphinx 2.3 in 2017 and has since become a full search database: real-time tables, a MySQL-protocol SQL interface, an Elasticsearch-like JSON API, columnar storage, joins and HNSW vector search. It is noticeably lighter on resources than Elasticsearch and often faster for full-text and log-style queries on a single box. Replication is Galera-based and distribution across nodes is done with distributed tables. A good fit if you like SQL, want an open-source (GPL-3.0) engine, and do not need the Elastic ecosystem.

Is Manticore Search open source?

Yes. Manticore Search is open source. License: GNU GPL v3.

Does Manticore Search support ACID transactions?

Partly. Manticore Search offers limited ACID guarantees (for example, single-record or single-partition transactions), with strong consistency.

Does Manticore Search scale horizontally?

Manticore Search has no built-in sharding; scaling out means partitioning data in your application. It is comfortable at medium scale (≤ 10 TB).

How can I run Manticore Search?

You can self-host it.

What is Manticore Search best for?

Manticore Search is a strong fit for site and product search with SQL; log search on a budget; and replacing legacy Sphinx installs. Think twice for teams needing automatic elastic sharding.

What are the best alternatives to Manticore Search?

Common alternatives to Manticore Search include Sphinx, Elasticsearch, OpenSearch, Typesense and Meilisearch. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

How popular is Manticore Search?

Manticore Search ranks #171 of 844 databases on the WhichDB Score (19.2/100), and #16 among search engine databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.