Radicle QuickSQL — Interactive

QuickSQL — write shorthand on the left, Oracle DDL appears on the right in real time radicle.it

Settings

Primary Key

PK type

Auto PK

Prefix PK with table name

Naming

Object prefix

Schema

SQL dialect

Data Types

DB version

Char semantics

Date data type

Boolean data type

Data language

Auto Columns

Audit columns

Row version

Row key (alphanumeric)

AI enrichment

Output

Include DROP statements

Generate INSERTs

Duality views

Editionable

Table API (TAPI)

APEX

Table compression

QuickSQL Reference

Tables

table_name	Creates a table with auto primary key
name /insert N	Generate N sample data rows
name /rest	Enable ORDS REST on the object
name /audit	Add created/updated/by columns
name /rowversion	Add row_version column for OCC
name /api	Generate Table API (TAPI package)
name /immutable	Immutable table (no UPDATE/DELETE)
name /history	Temporal history tracking
name /soda	SODA document store

Tables indented under another table automatically become children with a FK to the parent.

Data Types

vc / vcN	varchar2(4000) / varchar2(N)
vcNk	varchar2(Nk char)
num / num(p,s)	number / number(p,s)
int	integer
date	date
ts	timestamp
tstz / tswtz	timestamp with time zone
tswltz	timestamp with local time zone
bool	boolean (23c) or number(1)
json	json (23c) or clob check is json
clob / blob	clob / blob
vectN	vector(N,,)
file	APEX file upload columns

Column Directives

/nn	NOT NULL
/unique	UNIQUE constraint
/index	Create index on column
/lower	Trigger: force all lowercase
/upper	Trigger: force all uppercase
/default val	DEFAULT value
/check A,B,C	CHECK IN (A, B, C)
/between A,B	CHECK BETWEEN A AND B
/fk table	Explicit foreign key
/pk	Declare column as primary key

Views & JSON Duality

name = t1 t2	Join view across tables
dv name = t1	JSON Duality View (Oracle 23c)
> t1	Star schema: dimension table
< t1	Snowflake: sub-hierarchy

Settings

Add at the end of the file or use the ⚙ Settings panel in the header.

# settings = { pk: seq, semantics: CHAR, db: 23c }

pk	identityDataType \| guid \| seq \| none
genpk	yes \| no — auto-generate PK column
prefixpkwithtname	yes \| no — prefix PK col with table name
prefix	Object prefix (e.g. app_)
schema	Oracle schema name (e.g. HR)
dialect	SQL dialect — oracle (default)
db	Oracle version: 23c, 19c, 21c …
semantics	CHAR \| BYTE
date	DATE \| TIMESTAMP \| tswtz \| tswltz
boolean	native (23c) \| yn (char Y/N)
language	Sample data locale: EN \| JP \| KO
auditcols	yes \| no — created/updated/by columns
rowversion	yes \| no — row version for OCC
rowkey	yes \| no — alphanumeric row identifier
aienrichment	yes \| no — AI enrichment columns
drop	yes \| no — include DROP statements
inserts	yes \| no — generate INSERT data
dv	yes \| no — enable JSON Duality Views
editionable	yes \| no
api	yes \| no — Table API (TAPI) package
apex	yes \| no — APEX integration
compress	yes \| no — table compression

Quick Examples

Schema with automatic parent-child hierarchy:

departments /insert 2
   name /nn
   employees /insert 5
      name /nn vc50
      email /lower
      salary num(10,2)

Table with trigger and JSON column:

products /audit
   name vc100 /nn /upper
   price num(10,2) /nn
   specs json

Explicit FK + audit columns:

orders /audit /insert 10
   customer_id /fk customers
   total num(10,2) /nn
   status /check OPEN,CLOSED,PENDING

Keyboard Shortcuts

`Tab`	Indent 3 spaces
`Enter`	Auto-indent to match current line
`Esc`	Close Help and Settings panels

DDL updates in real time on every keystroke. The ER diagram updates 350 ms after the last keypress.

QSQL text is auto-saved to localStorage and restored on next visit. Each schema tab has its own content. Share link encodes the schema and ERD positions in the URL.