looker-dev

What this skill does

## Usage

All scripts can be executed using Node.js. Replace `<param_name>` and `<param_value>` with actual values.

**Bash:**
`node <skill_dir>/scripts/<script_name>.js '{"<param_name>": "<param_value>"}'`

**PowerShell:**
`node <skill_dir>/scripts/<script_name>.js '{\"<param_name>\": \"<param_value>\"}'`

Note: The scripts automatically load the environment variables from various .env files. Do not ask the user to set vars unless skill executions fails due to env var absence.


## Scripts


### create_git_branch

This skill is used to create a new git branch of a LookML project. This only works in dev mode.

Parameters:
- project_id (required): The unique ID of the LookML project.
- branch (required): The branch to create.
- ref (optional): The ref to start a newly created branch.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| project_id | string | The project_id | Yes |  |
| branch | string | The git branch to create | Yes |  |
| ref | string | The ref to use as the start of a new branch. Defaults to HEAD of current branch if not specified. | No | `` |


---

### create_project_directory

This skill creates a new directory within a specified LookML project.

Prerequisite: The Looker session must be in Development Mode. Use `dev_mode: true` first.

Parameters:
- project_id (required): The unique ID of the LookML project.
- directory_path (required): The path to the new directory within the project.

Output:
A confirmation message upon successful directory creation.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| project_id | string | The id of the project | Yes |  |
| directory_path | string | The path to create in the project | Yes |  |


---

### create_project_file

This skill creates a new LookML file within a specified project, populating
it with the provided content.

Prerequisite: The Looker session must be in Development Mode. Use `dev_mode: true` first.

Parameters:
- project_id (required): The unique ID of the LookML project.
- file_path (required): The desired path and filename for the new file within the project.
- content (required): The full LookML content to write into the new file.

Output:
A confirmation message upon successful file creation.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| project_id | string | The id of the project containing the files | Yes |  |
| file_path | string | The path of the file within the project | Yes |  |
| file_content | string | The content of the file | Yes |  |


---

### create_view_from_table

This skill generates boilerplate LookML views directly from the database schema.
It does not create model or explore files, only view files in the specified folder.

Prerequisite: The Looker session must be in Development Mode. Use `dev_mode: true` first.

Parameters:
- project_id (required): The unique ID of the LookML project.
- connection (required): The database connection name.
- tables (required): A list of objects to generate views for. Each object must contain `schema` and `table_name` (note: table names are case-sensitive). Optional fields include `primary_key`, `base_view`, and `columns` (array of objects with `column_name`).
- folder_name (optional): The folder to place the view files in (defaults to 'views/').

Output:
A confirmation message upon successful view generation, or an error message if the operation fails.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| project_id | string | The id of the project to create the view in. | Yes |  |
| connection | string | The database connection name. | Yes |  |
| tables | array | The tables to generate views for.
		Each item must be a map with:
		- schema (string, required)
		- table_name (string, required)
		- primary_key (string, optional)
		- base_view (boolean, optional)
		- columns (array of objects, optional): Each object must have 'column_name' (string). | Yes |  |
| folder_name | string | The folder to place the view files in (e.g., 'views'). | No | `views` |


---

### delete_git_branch

This skill is used to delete a git branch of a LookML project. This only works in dev mode.

Parameters:
- project_id (required): The unique ID of the LookML project.
- branch (required): The branch to delete.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| project_id | string | The project_id | Yes |  |
| branch | string | The git branch to delete | Yes |  |


---

### delete_project_directory

This skill permanently deletes a specified directory within a LookML project.

Prerequisite: The Looker session must be in Development Mode. Use `dev_mode: true` first.

Parameters:
- project_id (required): The unique ID of the LookML project.
- directory_path (required): The path to the directory within the project.

Output:
A confirmation message upon successful directory deletion.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| project_id | string | The id of the project | Yes |  |
| directory_path | string | The path to delete in the project | Yes |  |


---

### delete_project_file

This skill permanently deletes a specified LookML file from within a project.
Use with caution, as this action cannot be undone through the API.

Prerequisite: The Looker session must be in Development Mode. Use `dev_mode: true` first.

Parameters:
- project_id (required): The unique ID of the LookML project.
- file_path (required): The exact path to the LookML file to delete within the project.

Output:
A confirmation message upon successful file deletion.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| project_id | string | The id of the project containing the files | Yes |  |
| file_path | string | The path of the file within the project | Yes |  |


---

### dev_mode

This skill allows toggling the Looker IDE session between Development Mode and Production Mode.
Development Mode enables making and testing changes to LookML projects.

Parameters:
- enable (required): A boolean value.
  - `true`: Switches the current session to Development Mode.
  - `false`: Switches the current session to Production Mode.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| devMode | boolean | Whether to set Dev Mode. | No | `true` |


---

### get_connection_databases

This skill retrieves a list of databases available through a specified Looker connection.
This is only applicable for connections that support multiple databases.
Use `get_connections` to check if a connection supports multiple databases.

Parameters:
- connection_name (required): The name of the database connection, obtained from `get_connections`.

Output:
A JSON array of strings, where each string is the name of an available database.
If the connection does not support multiple databases, an empty list or an error will be returned.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| conn | string | The connection containing the databases. | Yes |  |


---

### get_connection_schemas

This skill retrieves a list of database schemas available through a specified
Looker connection.

Parameters:
- connection_name (required): The name of the database connection, obtained from `get_connections`.
- database (optional): An optional database name to filter the schemas.
  Only applicable for connections that support multiple databases.

Output:
A JSON array of strings, where each string is the name of an available schema.


#### Parameters

| Name | Type | Description | Required | Default |
| :--- | :--- | :--- | :--- | :--- |
| conn | string | The connection containing the schemas. | Yes |  |
| db | stri