v2.5.0 — now with EXPLAIN and EXPLAIN ANALYZE support

SQL for your
files, not just
databases.

Query XML, JSON, CSV, YAML, NEON and XLS files with familiar SQL syntax. No database needed. No ETL pipeline. Just your files and a query.

Open Explorer Studio → View on GitHub
7+ File formats
50+ SQL functions
NO Databases needed
MIT License
FQL string syntax
PHP
use FQL\Query;

$query = <<<FQL
    SELECT *
    FROM (./feed.xml).SHOP.SHOPITEM
    WHERE
        EAN = "1234567891011"
        OR PRICE <= 200
    ORDER BY PRICE DESC
    LIMIT 10
FQL;

$results = Query\Provider::fql($query)
    ->execute()
    ->fetchAll();
Fluent PHP API
PHP
use FQL\Query\Provider;
use FQL\Enum\Operator;

$results = Provider::fromFile('feed.xml')
  ->from('SHOP.SHOPITEM')
  ->select('PRODUCT', 'EAN', 'PRICE')
  ->where('PRICE',
    Operator::LESS_THAN_OR_EQUAL,
    500
  )
  ->orderBy('PRICE')->asc()
  ->limit(100)
  ->execute()
  ->fetchAll();

One API.
Every format.

Switch between formats without changing your query logic.

XML
XML
Product feeds, sitemaps, configs. Full stream support for large files.
JSON
JSON / NDJSON
Standard JSON and newline-delimited JSON with streaming.
CSV
CSV
Any delimiter, any encoding. Stream-processed row by row.
XLS
XLS / XLSX
Excel files without opening Excel. Query sheets directly.
YAML
YAML
Config files, data exports. Full query support.
NEON
NEON
Nette framework format. First-class support.
DIR
Directory
Query file metadata across entire directory trees recursively.
+
More coming
Parquet, MessagePack, TOML, INI in roadmap.

Not just SELECT *

Full SQL feature set, built for files.

Stream Processing
Process XML, JSON and CSV files with tens of thousands of rows without loading everything into memory. Built for real-world feed sizes.
🔗
JOIN Across Files
Join data from two different files — an XML feed with a CSV price list, for example. Cross-format joins just work.
Aggregations
SUM, COUNT, AVG, MIN, MAX, GROUP_CONCAT, ARRAY_MERGE and more. GROUP BY and HAVING included.
🔧
Data Functions
ROUND, MOD, EXPLODE, IMPLODE, DATE_FORMAT, UPPER, LOWER, TRIM and many more transformation functions.
📊
Schema Analysis
Automatic type detection, completeness scores, uniqueness analysis and enum detection — know your data quality instantly.
🗺️
DTO Mapping
Map query results directly to typed PHP objects. Skip the array juggling, work with real classes.

Library. API. Studio.

Use the PHP library directly, run the REST API, or open Explorer Studio — all powered by the same engine.

Open Source
FiQueLa
The core PHP library. Install via Composer, query any file in minutes. MIT licensed, battle-tested with 537 tests.
Command Line
FiQueLa CLI
Run FQL queries directly from your terminal. Supports remote files via URL, benchmarking and query inspection. Perfect for scripts and automation pipelines.
Self-hosted / Cloud
FiQueLa API
RESTful API with JWT auth, query history, pagination, export and S3 backup. Docker-ready. Host it yourself or use our cloud.
Web + Desktop
Explorer Studio
Visual query builder, SQL editor with autocomplete, schema browser, charts and export. Web app + Tauri desktop client for macOS, Linux and Windows.

Start querying
your files today.

Free to use. Open source. No database required.