Description
Use these skills when you need to explore the database structure, discover schema objects like tables and graphs, and execute custom SQL queries to interact with your data.
SKILL.md
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
execute_sql
Use this tool to execute DML SQL. Please use the googlesql interface for Spanner.
Parameters
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| sql | string | The sql to execute. | Yes |
execute_sql_dql
Use this tool to execute DQL SQL. Please use the googlesql interface for Spanner.
Parameters
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| sql | string | The sql to execute. | Yes |
list_graphs
Lists detailed graph schema information (node tables, edge tables, labels and property declarations) as JSON for user-created graphs. Filters by a comma-separated list of graph names. If names are omitted, lists all graphs. The output can be 'simple' (graph names only) or 'detailed' (full schema).
Parameters
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| graph_names | string | Optional: A comma-separated list of graph names. If empty, details for all graphs in user-accessible schemas will be listed. | No | `` |
| output_format | string | Optional: Use 'simple' to return graph names only or use 'detailed' to return the full information schema. | No | detailed |
list_tables
Lists detailed schema information (object type, columns, constraints, indexes) as JSON for user-created tables (ordinary or partitioned). Filters by a comma-separated list of names. If names are omitted, lists all tables in user schemas. The output can be 'simple' (table names only) or 'detailed' (full schema).
Parameters
| Name | Type | Description | Required | Default |
|---|---|---|---|---|
| table_names | string | Optional: A comma-separated list of table names. If empty, details for all tables in user-accessible schemas will be listed. | No | `` |
| output_format | string | Optional: Use 'simple' to return table names only or use 'detailed' to return the full information schema. | No | detailed |
More skills from the skills repository
View all 43 skillsamazon-location-service
integrate Amazon Location Service APIs
Jul 12API DevelopmentAWSMapsNavigationamplify-workflow
build full-stack apps with AWS Amplify
Jul 12AuthAWSDatabaseFrontend +1analyzer
analyze queried data for trends
Jul 12AnalyticsClickHouseData AnalysisStatisticsartifact-management
manage and organize analysis artifacts
Jul 12Data AnalysisProductivityReportingSQLattorney-assist
connect with attorneys for legal consultation
Jul 12ContractsLegalRisk Assessmentbuilding-pydantic-ai-agents
build AI agents with Pydantic AI
Jul 12AgentsLLMMulti-AgentPython
More from Cline
View publisherclickhouse
query ClickHouse databases via CLI
skills
Jul 12AnalyticsCLIClickHouseDatabasecline-session-history
search and browse Cline session history
skills
Jul 19AgentsHistoryProductivityconvex-design
build reactive backends with Convex
skills
Jul 12AuthBackendDatabaseReal-time +1cosmosdb-best-practices
optimize Azure Cosmos DB performance
skills
Jul 12AzureCosmos DBDatabaseNoSQL +1data-analyst
analyze ClickHouse analytics data
skills
Jul 12AnalyticsClickHouseDashboardsData Analysisdataproc-skills
manage Dataproc clusters and jobs
skills
Jul 12Data EngineeringOperations