tsql-syntax
Sintaxis básica de TailwindSQL: select, from, where, orderby, limit, etc. Trigger: Cuando necesitás escribir queries TailwindSQL.
- License 许可
- Apache-2.0
- 最近更新
- 2026-08-26
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- tsql-syntax
- license
- Apache-2.0
- metadata
- { "author": "gentleman-programming", "version": "1.0" }
- description
- Sintaxis básica de TailwindSQL: select, from, where, orderby, limit, etc. Trigger: Cuando necesitás escribir queries TailwindSQL.
03 SKILL.md 正文
Sintaxis TailwindSQL → SQL
| Token TailwindSQL | SQL Generado |
|---|---|
select-all |
SELECT * |
select-[col1,col2] |
SELECT col1, col2 |
from-[tabla] |
FROM tabla |
from-[usuarios as u] |
FROM usuarios AS u |
where-[campo=valor] |
WHERE campo=valor |
where-[age>18] |
WHERE age>18 |
where-[name LIKE "%john%"] |
WHERE name LIKE "%john%" |
orderby-[campo] |
ORDER BY campo |
orderby-[created_at desc] |
ORDER BY created_at DESC |
limit-[n] |
LIMIT n |
offset-[n] |
OFFSET n |
join-[otra_tabla] |
JOIN otra_tabla |
on-[a.id=b.user_id] |
ON a.id=b.user_id |
groupby-[campo] |
GROUP BY campo |
having-[count>5] |
HAVING count>5 |
Ejemplos
// Todos los campos
<QueryBlock query="select-all from-[User]" />
// Campos específicos
<QueryBlock query="select-[id,name,email] from-[User]" />
// Con condición
<QueryBlock query="select-all from-[User] where-[age>18]" />
// Con límite y orden
<QueryBlock query="select-[name] from-[User] where-[active=true] orderby-[created_at desc] limit-[10]" />
// JOIN
<QueryBlock query="select-[u.name,p.title] from-[User as u] join-[Posts as p] on-[u.id=p.user_id]" />
Notas
- Los nombres de tablas/columnas van entre
-[...] - Los valores no necesitan comillas para strings simples
- Para valores con espacios, usar comillas:
where-[name="Juan Perez"]
Resources
- Main Source: https://tailwindsql.com [TailwindSQL Official]
- GitHub: https://github.com/ptaberg/tailwindsql
04 同仓库更多 Skills
zustand-5
Zustand 5 state management patterns. Trigger: When managing React state with Zustand.
zod-4
Zod 4 schema validation patterns. Trigger: When using Zod for validation - breaking changes from v3.
x-bookmark-quote-posts
Workflow para revisar bookmarks de X/Twitter y convertirlos en drafts de quote posts. Accede a la sección de bookmarks vía browser headless, extrae posts recientes, y genera drafts con voz personal del usuario. No publica ni muta X — solo genera contenido para revisión. Trigger: X bookmarks, Twitter bookmarks, quote posts, bookmark automation, crear quote posts, revisar bookmarks, growth content X.
writing-skills
Use when creating new skills, editing existing skills, or verifying skills work before deployment
writing-plans
Use when you have a spec or requirements for a multi-step task, before touching code
work-unit-commits
Plan commits as reviewable work units. Trigger: implementation, commit splitting, chained PRs, or keeping tests and docs with code.