/

/spanner-basics

1,698

Assists in provisioning instances and databases, designing performant schemas, and querying data in Spanner. Use when designing primary keys, writing SQL queries or client library code, or diagnosing performance issues.

9 files
17.1 KB
Updated 2 weeks ago
GitHub
No alerts

Ask your Agent

Use this Skill: https://skilld.dev/gh/google/skills/spanner-basics

This session only. Nothing lands on disk.

referencespostgresql-dialect.md

951 B raw

≈238 tokens on demand. Your agent reads this file only when SKILL.md points to it.

PostgreSQL Dialect Support

Spanner provides PostgreSQL dialect support by expressing Spanner database features through a subset of open source PostgreSQL dialect constructs.

Key Considerations

Portability: Easier migration to other PostgreSQL databases if needed.
Familiarity: Leverages existing knowledge of PostgreSQL syntax and tools.
Ecosystem: Supports tools like psql and PostgreSQL drivers (via PGAdapter).

Features and Extensions

Spanner includes extensions to support Spanner-specific features within the PostgreSQL dialect:

Interleaved tables
Time to live (TTL)
Query hints

Limitations

Spanner does not support some open source PostgreSQL features:

Triggers
SERIAL
Transactional DDL
User-defined data types and operators

For more information, see The PostgreSQL language in Spanner.

Source: SKILL.md on GitHub

Third-party checks

No alerts10d3 checks · Risk SAFE

Gen Agent Trust Hub10d
This skill is designed to assist with Google Cloud Spanner administration and development. It provides standard workflows for schema design, SQL querying, and resource management using official Google tools and libraries. It includes appropriate safety guardrails requiring user confirmation for destructive database operations.
Socket10d
No alerts
Snyk10d
Risk: LOW · No issues

Provenance

Signed by skilld at becc4b8. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated 2 weeks ago

Capability

metadata: { "version": "1.0.0", "category": "Databases" }