Tool tree
Oracle FreeSQL lets you learn, practice, run, and share Oracle SQL, PL/SQL, and Quick SQL in a browser-based worksheet
get_workspace_contextAnswer
Return the current FreeSQL page, content, authentication mode, database version, schema mode, and available agent capabilities.
View tool JSON
{
"name": "get_workspace_context",
"kind": "answer",
"impl": "imperative",
"description": "Return the current FreeSQL page, content, authentication mode, database version, schema mode, and available agent capabilities.",
"inputSchema": {
"type": "object",
"properties": {}
}
}get_editor_contentAnswer
Read the visible SQL worksheet content and selected text without executing or changing it.
View tool JSON
{
"name": "get_editor_content",
"kind": "answer",
"impl": "imperative",
"description": "Read the visible SQL worksheet content and selected text without executing or changing it.",
"inputSchema": {
"type": "object",
"properties": {
"maxChars": {
"type": "integer",
"minimum": 100,
"maximum": 20000
}
}
}
}draft_sqlAction
Prepare SQL for review without inserting it into the editor or executing it.
View tool JSON
{
"name": "draft_sql",
"kind": "act",
"impl": "imperative",
"description": "Prepare SQL for review without inserting it into the editor or executing it.",
"inputSchema": {
"type": "object",
"properties": {
"sql": {
"type": "string",
"minLength": 1,
"maxLength": 20000
}
},
"required": [
"sql"
]
}
}find_tutorialsAnswer
Search public FreeSQL tutorials by title, description, or tags and return bounded metadata.
View tool JSON
{
"name": "find_tutorials",
"kind": "answer",
"impl": "imperative",
"description": "Search public FreeSQL tutorials by title, description, or tags and return bounded metadata.",
"inputSchema": {
"type": "object",
"properties": {
"search": {
"type": "string",
"maxLength": 200
},
"offset": {
"type": "integer",
"minimum": 0,
"maximum": 1000
},
"limit": {
"type": "integer",
"minimum": 1,
"maximum": 50
}
}
}
}get_tutorialAnswer
Read public or currently authorized tutorial metadata by slug.
View tool JSON
{
"name": "get_tutorial",
"kind": "answer",
"impl": "imperative",
"description": "Read public or currently authorized tutorial metadata by slug.",
"inputSchema": {
"type": "object",
"properties": {
"slug": {
"type": "string",
"minLength": 1,
"maxLength": 300
}
},
"required": [
"slug"
]
}
}get_tutorial_stepsAnswer
Read bounded tutorial steps by slug for explanation or worksheet guidance.
View tool JSON
{
"name": "get_tutorial_steps",
"kind": "answer",
"impl": "imperative",
"description": "Read bounded tutorial steps by slug for explanation or worksheet guidance.",
"inputSchema": {
"type": "object",
"properties": {
"slug": {
"type": "string",
"minLength": 1,
"maxLength": 300
},
"offset": {
"type": "integer",
"minimum": 0,
"maximum": 1000
}
},
"required": [
"slug"
]
}
}find_scriptsAnswer
Search public FreeSQL scripts by title, description, or tags and return bounded metadata.
View tool JSON
{
"name": "find_scripts",
"kind": "answer",
"impl": "imperative",
"description": "Search public FreeSQL scripts by title, description, or tags and return bounded metadata.",
"inputSchema": {
"type": "object",
"properties": {
"search": {
"type": "string",
"maxLength": 200
},
"offset": {
"type": "integer",
"minimum": 0,
"maximum": 1000
},
"limit": {
"type": "integer",
"minimum": 1,
"maximum": 50
}
}
}
}get_scriptAnswer
Read public or currently authorized script metadata by slug.
View tool JSON
{
"name": "get_script",
"kind": "answer",
"impl": "imperative",
"description": "Read public or currently authorized script metadata by slug.",
"inputSchema": {
"type": "object",
"properties": {
"slug": {
"type": "string",
"minLength": 1,
"maxLength": 300
}
},
"required": [
"slug"
]
}
}get_script_statementsAnswer
Read bounded script statements by slug for explanation or comparison.
View tool JSON
{
"name": "get_script_statements",
"kind": "answer",
"impl": "imperative",
"description": "Read bounded script statements by slug for explanation or comparison.",
"inputSchema": {
"type": "object",
"properties": {
"slug": {
"type": "string",
"minLength": 1,
"maxLength": 300
},
"offset": {
"type": "integer",
"minimum": 0,
"maximum": 1000
}
},
"required": [
"slug"
]
}
}list_sample_schemasAnswer
List sample-schema names currently available to the selected FreeSQL environment.
View tool JSON
{
"name": "list_sample_schemas",
"kind": "answer",
"impl": "imperative",
"description": "List sample-schema names currently available to the selected FreeSQL environment.",
"inputSchema": {
"type": "object",
"properties": {}
}
}find_database_objectsAnswer
Search bounded database objects such as tables, views, packages, procedures, and indexes in an authorized schema.
View tool JSON
{
"name": "find_database_objects",
"kind": "answer",
"impl": "imperative",
"description": "Search bounded database objects such as tables, views, packages, procedures, and indexes in an authorized schema.",
"inputSchema": {
"type": "object",
"properties": {
"schema": {
"type": "string",
"maxLength": 128
},
"objectType": {
"type": "string",
"enum": [
"ALL",
"TABLE",
"VIEW",
"FUNCTION",
"PACKAGE",
"PACKAGE BODY",
"INDEX",
"MLE MODULE",
"MLE ENVIRONMENT",
"MATERIALIZED VIEW LOGS",
"TYPE",
"SYNONYM",
"PUBLIC_SYNONYM",
"TRIGGER",
"SEQUENCE",
"PROCEDURE",
"MATERIALIZED VIEW"
]
},
"search": {
"type": "string",
"maxLength": 200
},
"offset": {
"type": "integer",
"minimum": 0,
"maximum": 1000
},
"limit": {
"type": "integer",
"minimum": 1,
"maximum": 50
}
}
}
}get_table_columnsAnswer
Return bounded column metadata for an authorized table or view.
View tool JSON
{
"name": "get_table_columns",
"kind": "answer",
"impl": "imperative",
"description": "Return bounded column metadata for an authorized table or view.",
"inputSchema": {
"type": "object",
"properties": {
"owner": {
"type": "string",
"maxLength": 128
},
"name": {
"type": "string",
"minLength": 1,
"maxLength": 128
}
},
"required": [
"name"
]
}
}get_object_argumentsAnswer
Return bounded arguments for an authorized procedure, function, or package object.
View tool JSON
{
"name": "get_object_arguments",
"kind": "answer",
"impl": "imperative",
"description": "Return bounded arguments for an authorized procedure, function, or package object.",
"inputSchema": {
"type": "object",
"properties": {
"owner": {
"type": "string",
"maxLength": 128
},
"name": {
"type": "string",
"minLength": 1,
"maxLength": 128
}
},
"required": [
"name"
]
}
}get_object_ddlAnswer
Read the generated DDL for an authorized database object without executing it.
View tool JSON
{
"name": "get_object_ddl",
"kind": "answer",
"impl": "imperative",
"description": "Read the generated DDL for an authorized database object without executing it.",
"inputSchema": {
"type": "object",
"properties": {
"owner": {
"type": "string",
"maxLength": 128
},
"name": {
"type": "string",
"minLength": 1,
"maxLength": 128
},
"type": {
"type": "string",
"enum": [
"ALL",
"TABLE",
"VIEW",
"FUNCTION",
"PACKAGE",
"PACKAGE BODY",
"INDEX",
"MLE MODULE",
"MLE ENVIRONMENT",
"MATERIALIZED VIEW LOGS",
"TYPE",
"SYNONYM",
"PUBLIC_SYNONYM",
"TRIGGER",
"SEQUENCE",
"PROCEDURE",
"MATERIALIZED VIEW"
]
}
},
"required": [
"name",
"type"
]
}
}get_connection_contextAnswer
Return non-secret database and schema context. Credentials, access tokens, hosts, ports, and connection strings are never returned.
View tool JSON
{
"name": "get_connection_context",
"kind": "answer",
"impl": "imperative",
"description": "Return non-secret database and schema context. Credentials, access tokens, hosts, ports, and connection strings are never returned.",
"inputSchema": {
"type": "object",
"properties": {}
}
}list_owned_schemasAnswer
List safe metadata for schemas owned by the signed-in FreeSQL user.
View tool JSON
{
"name": "list_owned_schemas",
"kind": "answer",
"impl": "imperative",
"description": "List safe metadata for schemas owned by the signed-in FreeSQL user.",
"inputSchema": {
"type": "object",
"properties": {}
}
}run_readonly_sqlAction
Execute one bounded SELECT statement in the current authorized FreeSQL schema, update the visible query-result pane, and return a compact result summary.
View tool JSON
{
"name": "run_readonly_sql",
"kind": "act",
"impl": "imperative",
"description": "Execute one bounded SELECT statement in the current authorized FreeSQL schema, update the visible query-result pane, and return a compact result summary.",
"inputSchema": {
"type": "object",
"properties": {
"sql": {
"type": "string",
"minLength": 1,
"maxLength": 10000
},
"maxRows": {
"type": "integer",
"minimum": 1,
"maximum": 100
}
},
"required": [
"sql"
]
}
}get_execution_planAnswer
Generate an execution plan for one read-only SELECT statement and update the visible explain-plan pane.
View tool JSON
{
"name": "get_execution_plan",
"kind": "answer",
"impl": "imperative",
"description": "Generate an execution plan for one read-only SELECT statement and update the visible explain-plan pane.",
"inputSchema": {
"type": "object",
"properties": {
"sql": {
"type": "string",
"minLength": 1,
"maxLength": 10000
}
},
"required": [
"sql"
]
}
}