Wikidata-SQL

Run SQL queries against Wikidata. Instead of writing SPARQL, write familiar SQL using Wikidata Q-IDs as table names.

Install

pip install WikiSQL

Quick Start

wikisql                                          # interactive REPL
wikisql "SELECT * FROM Q845945 LIMIT 10"         # single query
wikisql --sparql "SELECT * FROM Q845945 LIMIT 10" # show generated SPARQL
wikisql -l ja "SELECT * FROM Q845945 LIMIT 10"   # Japanese labels

How It Works

A Q-ID in the FROM clause creates a virtual table of all entities with that class:

-- All Shinto shrines (instances of Q845945)
SELECT * FROM Q845945 LIMIT 10;

-- Subclasses of Shinto shrine (P279 instead of default P31)
SELECT * FROM P279:Q845945 LIMIT 10;

Selecting Properties

Use Wikidata property IDs as column names. By default, values show human-readable labels:

-- Show country and population of cities
SELECT item, P17, P1082 FROM Q515 LIMIT 5;

Append _qid to get the raw Wikidata entity ID instead:

SELECT P17, P17_qid FROM Q515 LIMIT 3;

WHERE Filtering

Filter by label (human-readable name):

SELECT item, P17 FROM Q515 WHERE P17 = 'France' LIMIT 5;

Filter by QID (entity ID):

SELECT item, P17 FROM Q515 WHERE P17_qid = 'Q142' LIMIT 5;

JOINs

Join two virtual tables on a shared property:

SELECT * FROM Q845945 s JOIN Q5 p ON s.P17 = p.P27 LIMIT 5;

Column Reference

REPL Commands

• \sparql - Toggle SPARQL display on/off
• \q / quit / exit - Exit