Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- description: Query information_schema.tables
statement: SELECT * FROM information_schema.tables
defaultDatabase: testdb
metadata: '{}'
querySpan:
type: 3
results: []
sourcecolumns:
- server: ""
database: information_schema
schema: ""
table: tables
column: ""
predicatecolumns: []
- description: Query information_schema.columns with WHERE clause
statement: SELECT table_name, column_name FROM information_schema.columns WHERE table_schema = 'testdb'
defaultDatabase: testdb
metadata: '{}'
querySpan:
type: 3
results: []
sourcecolumns:
- server: ""
database: information_schema
schema: ""
table: columns
column: ""
predicatecolumns: []
- description: Query _statistics_ database
statement: SELECT * FROM _statistics_.table_statistics
defaultDatabase: testdb
metadata: '{}'
querySpan:
type: 3
results: []
sourcecolumns:
- server: ""
database: _statistics_
schema: ""
table: table_statistics
column: ""
predicatecolumns: []
- description: Query sys metadatabase (StarRocks system db; Doris has no sys, and StarRocks has no mysql/__internal_schema)
statement: SELECT * FROM sys.grants_to_roles
defaultDatabase: testdb
metadata: '{}'
querySpan:
type: 3
results: []
sourcecolumns:
- server: ""
database: sys
schema: ""
table: grants_to_roles
column: ""
predicatecolumns: []
- description: Query user table
statement: SELECT * FROM users
defaultDatabase: testdb
metadata: |-
{
"name": "testdb",
"schemas": [
{
"name": "",
"tables": [
{
"name": "users",
"columns": [
{
"name": "id",
"position": 1
},
{
"name": "name",
"position": 2
}
]
}
]
}
]
}
querySpan:
type: 1
results: []
sourcecolumns:
- server: ""
database: testdb
schema: ""
table: users
column: ""
predicatecolumns: []