skills.rest
gemini-cli-extensions
gemini-cli-extensionsOFFICIAL
Explore all skills by this author →
GitHub

cloud-sql-postgres-vectorassist

Automate vector search configuration and optimization on Cloud SQL for PostgreSQL.

42|7|Updated Sep 12, 2025
Search Tags:#postgresql#embeddings#sql#semantic-search#vector-search#database-optimization#cloud-sql
One-click install
npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-vectorassist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: cloud-sql-postgres-vectorassist
Source: https://github.com/gemini-cli-extensions/cloud-sql-postgresql/tree/main/skills/cloud-sql-postgres-vectorassist
Command: npx skills add https://github.com/gemini-cli-extensions/cloud-sql-postgresql --skill cloud-sql-postgres-vectorassist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Manually configuring production-ready vector search workloads on Cloud SQL for PostgreSQL requires deep expertise in index tuning, embedding management, and query optimization, leading to hours of trial and error and suboptimal performance for teams without specialized database knowledge.

Core Features & Use Cases

  • Vector Specification Management: Define, modify, and apply tailored vector search configurations for your tables, with auto-generated SQL recommendations for index creation and embedding pipelines.
  • Optimized Query Generation: Automatically produce high-performance vector similarity search SQL with support for prefiltering, custom recall targets, and configurable distance functions.
  • End-to-End Workflow: Streamline the full vector search setup process from initial configuration to index application and query execution, no manual database tuning required. Use Case: A team building a semantic product search feature can use this skill to automatically configure the optimal vector index, set up embedding generation, and produce ready-to-run similarity queries for natural language product searches.

Quick Start

Ask your AI agent to use the cloud-sql-postgres-vectorassist skill to define a vector search specification for your product catalog table and generate a similarity query for "wireless bluetooth headphones".

Frequently Asked Questions about cloud-sql-postgres-vectorassist

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up vector search on Cloud SQL for PostgreSQL?▼

Setting up vector search on Cloud SQL for PostgreSQL involves defining vector specifications, tuning indexes, and generating similarity queries. This skill automates that end-to-end configuration process to avoid manual database tuning.

What is the best way to optimize vector similarity search queries in Postgres?▼

Optimizing vector similarity search in Postgres requires tuning indexes and configuring distance functions. This skill automatically produces high-performance SQL with prefiltering, custom recall targets, and configurable distance functions.

How does vector index tuning work for semantic search in Cloud SQL?▼

Vector index tuning for semantic search in Cloud SQL involves generating tailored configurations for your tables. This skill provides auto-generated SQL recommendations for index creation and embedding pipelines to streamline the process.

Can I use custom embedding models with Cloud SQL Postgres vector search?▼

Yes, you can use custom embedding models with Cloud SQL Postgres vector search. This skill supports custom embedding model integration and filtered vector query execution to meet specific semantic retrieval requirements.

How do I generate prefiltered vector similarity queries for a product catalog?▼

Generating prefiltered vector similarity queries for a product catalog requires specifying search configurations. This skill produces ready-to-run SQL for natural language searches based on your defined vector specifications.

Related Skills

Explore More Software Engineering Skills→
brendadeeznuts1111brendadeeznuts1111

django-cloud-sql-postgres

Deploy Django applications on Google App Engine with Cloud SQL PostgreSQL.

Community
Advanced
interflownexinterflownex
2

cloud-sql-postgres-vectorassist

Configure vector indexes and generate optimized SQL queries for Cloud SQL for PostgreSQL.

Community
Advanced
discountedcookiediscountedcookie

postgres-vectors

Store 384-dimensional embeddings in Postgres and query cosine similarity with pgvector.

Community
Advanced
1lastphoenix1lastphoenix
7

pgvector-semantic-search

Store embeddings in PostgreSQL and query them via nearest-neighbor distance.

Community
Advanced