> ## Documentation Index
> Fetch the complete documentation index at: https://docs.corvic.ai/llms.txt
> Use this file to discover all available pages before exploring further.
# Python & SQL
> Run AI-assisted Python and SQL transformations on your tables and spaces.
When the built-in actions don't cover a transformation you need, drop down to code. The **Python** and **SQL** actions let you transform data on the Workflow canvas with AI assistance — describe what you want, and Corvic helps write the code, which you can then review, edit, and run.
## When to use them
Use Python or SQL for custom logic that the dedicated actions (Augment, Join, Extract Tables, and so on) don't express directly:
* Reshaping, pivoting, or aggregating columns
* Custom cleaning, parsing, or feature derivation
* Filtering and reformatting before embedding
* Calling external APIs from your [API Secret Vault](/features/api-secret-vault) (Python)
On the canvas these appear as **Python** (`execute_python`) and **SQL** (`execute_sql`) actions. The agent's reasoning chain refers to the same `execute_python` capability when it runs code to answer a question.
## Python
The Python action runs an AI-assisted Python transform over the input table. Describe the transformation in plain language; Corvic drafts the code, and you can inspect and modify it before running.
Python is also how agents call connected external APIs — credentials from the [API Secret Vault](/features/api-secret-vault) are injected automatically, so your code references a connection by name rather than handling raw secrets.
📸 Screenshot to add: the Python action panel (prompt, generated code, run) — save as /images/action-python.png
## SQL
The SQL action runs an AI-assisted SQL query over the input table. Use it for set-based transformations — joins, aggregations, window functions, and filtering — expressed in familiar SQL.
📸 Screenshot to add: the SQL action panel (prompt, generated query, run) — save as /images/action-sql.png
## Where they run
Python and SQL actions can be applied to **Corvic Table** outputs, and can also run directly on **Space** outputs — letting you post-process embeddings and their associated data without leaving the canvas.
## Usage
Click the **+** next to a table or space node and choose **Python** or **SQL**.
Write what you want in plain language. Corvic generates the code or query.
Inspect the generated code, adjust it as needed, and copy it if you want to reuse it.
Execute the action to produce a new output you can use downstream.
## Related Documentation
Build pipelines on the canvas.
Call external APIs from Python.
See all available canvas actions.