sf-soql

Convert natural-language data requests into executable SOQL queries.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/dcinzona/folios --skill sf-soql-dcinzona
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sf-soql
Source: https://github.com/dcinzona/folios/tree/main/.agents/skills/sf-soql
Command: npx skills add https://github.com/dcinzona/folios --skill sf-soql-dcinzona

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

SOQL query generation, optimization, and analysis from natural-language requests with a 100-point scoring mindset to help developers write safer, faster queries without trial-and-error.

Core Features & Use Cases

  • Natural Language to SOQL: translate requests into executable queries
  • Query Optimization & Security: improve selectivity, enforce security, and plan for governor limits
  • Relationship Queries & Aggregates: parent-child and aggregate patterns with correct field coverage
  • Quick Validation & Patterns: guidance and reference patterns for safe query design

Quick Start

Describe your data needs and I will generate an optimized SOQL query with security considerations.

Frequently Asked Questions about sf-soql

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

FAQPage Schema
How do I write a SOQL query from a plain-English request?

You can generate a SOQL query from plain-English by translating your data needs into executable syntax. This process applies performance and security considerations to ensure safe, efficient queries without trial-and-error.

What is the best way to optimize SOQL queries for Salesforce governor limits?

To optimize SOQL queries for governor limits, apply indexing, selectivity, and field coverage constraints. Analyzing the SOQL plan helps satisfy these constraints and prevents hitting limits in Apex and automation contexts.

How do SOQL relationship queries work for parent-child traversals?

SOQL relationship queries work by traversing parent-child and aggregate patterns with correct field coverage. They allow you to extract related data efficiently while maintaining query performance and security.

Can I use natural language to generate aggregate SOQL queries?

Yes, you can use natural language to generate aggregate SOQL queries. The conversion process handles aggregate patterns and relationship traversals while ensuring the resulting query satisfies indexing and selectivity constraints.

Why does my SOQL query fail selectivity checks?

SOQL queries fail selectivity checks when they do not meet indexing and field coverage constraints. Analyzing the query plan and enforcing security considerations helps identify and resolve these performance bottlenecks.

Does generated SOQL work with Apex selector patterns?

Yes, generated SOQL works with Apex selector patterns. The query generation supports integration with data tooling and selector patterns across UI, automation, and Apex contexts while maintaining security.