bradleyboy/tuql
bradleyboy/tuql has 1,073 GitHub stars and 41 forks. GitHot measured 0 stars in 24 hours, -1 in 7 days, and -2 in 15 days. Last checked 2026-11-22 19:11 UTC. Last push 2021-06-06.
計測したスター増加
- 24時間
- 0
- 7日間
- -1
- 15日間
- -2
- 1か月
- 履歴を収集中
期間ごとの純増数です。期間は重複しており、日別の値ではありません。未計測の値は空欄です。スター数は注目度の指標であり、品質の保証ではありません。
概要
Automatically create a GraphQL server from a SQLite database or a SQL file
データREADME.md
オリジナルtuql

Pronounced: Too cool
tuql is a simple tool that turns a sanely formatted sqlite database into a graphql endpoint. It tries to infer relationships between objects, currently supporting belongsTo, hasMany and belongsToMany. It also forms the basic mutations necessary to create, update, and delete objects, as well as assoicate many-to-many relationships.
Installing
npm install -g tuql
Using
tuql --db path/to/database.sqlite
You can also optionally set the port and enable graphiql:
tuql --db path/to/database.sqlite --port 8888 --graphiql
Or, you can use a sql file with statements to build up an in-memory database:
tuql --infile path/to/db_dump.sql --graphiql
If you'd like to print out the schema itself, use:
tuql --db path/to/database.sqlite --schema
Or send it to a file:
tuql --db path/to/database.sqlite --schema > schema.graphql
How it works
Imagine your sqlite schema looked something like this:
| posts | users | categories | category_post |
|---|---|---|---|
| id | id | id | category_id |
| user_id | username | title | post_id |
| title | |||
| body |
tuql will automatically define models and associations, so that graphql queries like this will work right out of the box:
{
posts {
title
body
user {
username
}
categories {
title
}
}
}
tuql works one of two ways. It prefers to map your schema based on the foreign key information in your tables. If foreign keys are not present, tuql assumes the following about your schema in order to map relationships:
- The primary key column is named
idorthing_idorthingId, wherethingis the singular form of the table name. Example: For a table named posts, the primary key column should be namedid,post_idorpostId. - Similarly, foreign key columns should be
thing_idorthingId, wherethingis the singular form of the associated table. - For many-to-many associations, the table name should be in the form of
foo_barorbar_foo(ordering is not important). The columns should follow the same pattern as #2 above.
関連プロジェクトを探す
読み込み中…