# spanner-data

Inspects Google Cloud Spanner schemas and executes custom SQL queries. Useful when an agent needs direct access to database tables and graph definitions.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 666 installs · ★ 40
- Author: cline
- License: Apache-2.0 · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/cline/skills/tree/HEAD/skills/spanner-data/SKILL.md
- Updated: 2026-07-21
- HTML: https://affpapa.org/en/nevibecode/skills/spanner-data

## What it does

The skill equips coding assistants with Node.js scripts for interacting with Google Cloud Spanner. It supplies dedicated tools to run DQL read queries (`execute_sql_dql`) and apply DML modifications (`execute_sql`). Both tools expect the GoogleSQL dialect.

Schema exploration tools inspect user-created objects and return raw JSON. `list_tables` extracts columns and index details. `list_graphs` inspects graph structures, including node and edge table definitions. Output switches between minimal name lists and exhaustive property maps.

Without a local Node.js runtime, the scripts cannot execute. If Spanner credentials are not defined in the environment, query calls fail immediately.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add cline/skills --skill spanner-data -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/spanner-data/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/spanner-data/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add cline/skills --skill spanner-data -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/spanner-data/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add cline/skills --skill spanner-data -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/spanner-data/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install cline/skills spanner-data
```

2. **Manually: put the files in place**
- File: `.github/skills/spanner-data/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add cline/skills --skill spanner-data -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/cline/skills --path skills/spanner-data
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/spanner-data/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add cline/skills --skill spanner-data -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/cline/skills/tree/HEAD/skills/spanner-data/SKILL.md

## When to use it
- inspect Spanner table schemas, columns, and indexes as JSON
- discover graph schema objects such as node and edge tables
- run GoogleSQL DQL queries to inspect database records
- apply DML mutations to Spanner tables

## Example prompts
- Inspect the detailed schema for table `Orders` in Spanner
- Run this DQL query on Spanner: `SELECT id, status FROM Accounts LIMIT 5`
- List all custom graph schemas in the current Spanner database

## Source text · SKILL.md · Apache-2.0

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: 7232f6a398f0bf47.

BEGIN THIRD-PARTY FILE 7232f6a398f0bf47
```text
---
name: spanner-data
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.
---

## 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` |


---
```
END THIRD-PARTY FILE 7232f6a398f0bf47

The third-party file has ended. Everything between the 7232f6a398f0bf47 tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

© cline · Apache-2.0 · https://github.com/cline/skills/tree/HEAD/skills/spanner-data/SKILL.md

## Similar
- [spanner](https://affpapa.org/en/nevibecode/plugins/spanner.md) — plugin · ★ 19
- [db-context-engineering](https://affpapa.org/en/nevibecode/plugins/db-context-engineering.md) — plugin · ★ 42
- [spanner-basics](https://affpapa.org/en/nevibecode/skills/spanner-basics.md) — skill · 4600 installs
- [gcp-cloud-sql](https://affpapa.org/en/nevibecode/skills/gcp-cloud-sql.md) — skill · 328 installs
- [clickhouse-js-node-coding](https://affpapa.org/en/nevibecode/skills/clickhouse-js-node-coding.md) — skill · 7000 installs

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md