Query data from
any remote source with SQL

Streambiki =
Queries as a Service (QaaS)

Extract from JSON, CSV, TSV or NDJSON
Output to JSON, CSV, TSV or NDJSON
Use and share your data your way

Sign Up for Beta Access — it's free
to stay informed about our launch
https://remote-server.com/users.json
{
  "name": "users",
  "people": [
    {
      "name": "Bob",
      "age": "32",
      "status": "offline"
      "cityId": "NY"
    },
    {
      "name": "Sophie",
      "age": "20",
      "status": "online"
      "cityId": "LA"
    },
    {
      "name": "Karen",
      "age": "23",
      "status": "online"
      "cityId": "NY"
    }
  ],
  "cities": [
    {
      "id": "NY",
      "city": "New York"
    },
    {
      "id": "LA",
      "city": "Los Angeles"
    }
  ]
}
            
My Custom Query
source
https://remote-server.com/users.json
SELECT 
    name,
    CAST(age AS INT) AS age,
    city
FROM 
    people
JOIN
    cities ON people.cityId = cities.id
WHERE 
    people.status = "online"
            
https://streambiki.com/me/my-custom-query.json
[
    {
        "name": "Sophie",
        "age": 20,
        "city": "Los Angeles"
    },
    {
        "name": "Karen",
        "age": 23,
        "city": "New York"
    }
]
            
https://streambiki.com/me/my-custom-query.csv
name age city
Sophie 20 Los Angeles
Karen 23 New York

Your data at your fingertips
with zero maintenance

Convert between formats

Read your external source and work with tables like a local database

Input formats: CSV, TSV, JSON, NDJSON

Output the results in a different format

Output formats: CSV, TSV, JSON, NDJSON

Model data to your needs

Turn properties into table columns

SELECT only the properties you need

Rename properties with your own alias

CAST() to ensure strict data typing

My Custom Query
source
https://remote-server.com/users.json
SELECT 
    name AS firstName,
    CAST(age AS INT) AS age
FROM 
    people
        

Use the power of SQL
to get the result you're looking for

Filter with a WHERE clause

Aggregate with common SQL functions like COUNT(), SUM(), AVG(), MIN(), MAX()

Write conditions with IF() or CASE()

My Custom Query
source
https://remote-server.com/users.json
SELECT 
    COUNT(*) as totalOnline,
    SUM(IF(name="Bob"),1,0) as howManyBobs,
    AVG(age) AS averageAge,
    MIN(age) AS youngestAge,
    MAX(age) AS oldestAge
FROM 
    people
WHERE 
    status = "online"
        

Get insight into different data sets
like it's your own relational database

Turn nested arrays into tables

Query any direction with JOIN, LEFT JOIN, RIGHT JOIN, WHERE EXISTS()

Join multiple URLs

coming
My Custom Query
users
https://remote-server.com/users.json
jobs
https://other-server.com/jobs.csv
plus-sign
SELECT 
    name,
    CAST(age AS INT) AS age,
    city
FROM 
    users.people
JOIN
    users.cities ON users.people.cityId = users.cities.id
LEFT JOIN
    jobs ON users.people.jobId = jobs.id
        

Share your query results
with easy but controlled access to others

Public URLs

Private URLs

Result caching

coming

Usage analytics

coming
share-square-line
secure-account

Seamless integration into your code
built by developers for developers

Use our service as your back-end API

Work with every programming language

Improve the scalability of your project without additional complexity

My IDE
fetch('https://streambiki.com/me/my-custom-query.json', {
  method: 'GET',
  headers: {
    contentType: 'application/json',
  }
})
  .then(response => response.json())
  .then(data => {
    console.log(data);
  })
  .catch(error => {
    alert(error.message);
  });
        

Our mission

Streambiki

“It's our mission to bring our experience in data management to everyone. And make it easy and affordable to exchange data between businesses.“

Geert Van Bommel

CEO, Streambiki

Sign Up for Beta Access — it's free
to stay informed about our launch