{"ok":true,"site":{"host":"freesql.com","url":"https://freesql.com/?webmcp=true","type":"live","desc":"Oracle FreeSQL lets you learn, practice, run, and share Oracle SQL, PL/SQL, and Quick SQL in a browser-based worksheet","tools":[{"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":{}},"executable":true,"handlerField":"execute"},{"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}}},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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}}},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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}}},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"name":"list_sample_schemas","kind":"answer","impl":"imperative","description":"List sample-schema names currently available to the selected FreeSQL environment.","inputSchema":{"type":"object","properties":{}},"executable":true,"handlerField":"execute"},{"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}}},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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":{}},"executable":true,"handlerField":"execute"},{"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":{}},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"},{"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"]},"executable":true,"handlerField":"execute"}],"category":"Developer Tools","favicon":"/favicons/freesql.com.png","apiSurface":"spec","toolCount":18}}