π οΈ Show & Tell: What Custom Copilot Skills Have You Built? Share Your SKILL.md Files! #194436
Replies: 9 comments 2 replies
-
|
I need to see photos |
Beta Was this translation helpful? Give feedback.
-
|
thanks this really helps alot. |
Beta Was this translation helpful? Give feedback.
This comment was marked as off-topic.
This comment was marked as off-topic.
This comment was marked as off-topic.
This comment was marked as off-topic.
-
|
where computer buy & ? 121 |
Beta Was this translation helpful? Give feedback.
-
π§© Skill nameAI DB Investigator Repository: π― Problem it solvesMost AI database help still behaves like direct question-answering. But real database work usually requires investigation first. A slow endpoint, suspicious schema, missing index, unclear relation, or bad data model is rarely solved by one immediate answer. The useful flow is usually:
This skill is designed to make Copilot / AI agents approach database analysis as a structured investigation rather than a guessing process. πSKILL.mdThe skill defines a local DB investigation protocol with explicit safety and documentation rules. Core characteristics:
Supported engines include:
The skill starts by requiring: node scripts/diagnose.mjsor: npm run diagnoseThen it resolves the explicit target environment and engine before running any database command. One of the main design rules is:
Another important rule:
The skill also requires investigation artifacts to be updated before ending the work:
So the AI does not only answer the user - it leaves behind reusable investigation context. π₯οΈ Where it worksThe skill is intended for local AI-assisted development workflows where the model can inspect a project and use local scripts/tools. Use cases:
It is not a monitoring dashboard and not a database admin replacement. It is a focused investigation protocol for AI agents. π‘ One thing I learnedThe biggest lesson was that AI database work needs guardrails before intelligence. Without structure, the model may jump too fast into conclusions. For database work, that is risky. The important parts are not only βwhich query to runβ, but also:
So the skill became less about generating SQL and more about enforcing a disciplined investigation process. The direction Iβm exploring is:
Feedback is very welcome, especially around database investigation flows, PostgreSQL-specific checks, and how this could be improved for Copilot / agent workflows. |
Beta Was this translation helpful? Give feedback.
-
|
Fuck off
β¦On Sat, May 23, 2026, 11:06β―AM Jonathan Miller ***@***.***> wrote:
π§© Skill name
*AI DB Investigator*
A read-only local database investigation skill for AI-assisted development.
Repository:
https://github.com/miller-28/skill-ai-db-investigator
------------------------------
π― Problem it solves
Most AI database help still behaves like direct question-answering.
But real database work usually requires investigation first.
A slow endpoint, suspicious schema, missing index, unclear relation, or
bad data model is rarely solved by one immediate answer. The useful flow is
usually:
1. identify the target environment
2. identify the database engine
3. inspect existing runtime context
4. understand entities and relationships
5. run bounded read-only queries
6. document findings
7. separate symptoms from root causes
8. suggest safe next actions
This skill is designed to make Copilot / AI agents approach database
analysis as a structured investigation rather than a guessing process.
------------------------------
π Your SKILL.md
The skill defines a local DB investigation protocol with explicit safety
and documentation rules.
Core characteristics:
- read-only by design
- mandatory environment resolution
- mandatory engine resolution
- mandatory diagnostic step before DB commands
- support for multiple engines
- runtime database context files
- query audit trail per investigation session
- generated investigation reports
- Mermaid schema context
- no credential collection in chat
- no secrets echoed in responses or logs
Supported engines include:
- PostgreSQL
- MongoDB
- MySQL
- MariaDB
- SQL Server
- SQLite
- Redis
- Elasticsearch / OpenSearch
- Cassandra
- Neo4j
The skill starts by requiring:
node scripts/diagnose.mjs
or:
npm run diagnose
Then it resolves the explicit target environment and engine before running
any database command.
One of the main design rules is:
Never assume or auto-pick an environment or database engine when the user
did not explicitly provide one.
Another important rule:
The bridge is read-only. Do not attempt INSERT, UPDATE, DELETE, DDL, or
destructive commands through the skill.
The skill also requires investigation artifacts to be updated before
ending the work:
- db-context/<env>/<engine>/schema.mermaid
- db-context/<env>/<engine>/entity-map.md
- investigations/<env>/<engine>/<session>/investigation-report.md
So the AI does not only answer the user - it leaves behind reusable
investigation context.
------------------------------
π₯οΈ Where it works
The skill is intended for local AI-assisted development workflows where
the model can inspect a project and use local scripts/tools.
Use cases:
- database schema investigation
- PostgreSQL query analysis
- entity relationship mapping
- index review
- production-style DB debugging
- bounded read-only data inspection
- AI-assisted technical diagnosis
- documenting database findings for future sessions
It is not a monitoring dashboard and not a database admin replacement.
It is a focused investigation protocol for AI agents.
------------------------------
π‘ One thing I learned
The biggest lesson was that AI database work needs guardrails before
intelligence.
Without structure, the model may jump too fast into conclusions.
For database work, that is risky.
The important parts are not only βwhich query to runβ, but also:
- which environment is being inspected
- which engine is being used
- whether the command is safe
- whether the result is documented
- whether the next AI session can continue from the previous context
So the skill became less about generating SQL and more about enforcing a
disciplined investigation process.
The direction Iβm exploring is:
AI-assisted development should not only generate code.
It should also investigate systems carefully.
Feedback is very welcome, especially around database investigation flows,
PostgreSQL-specific checks, and how this could be improved for Copilot /
agent workflows.
β
Reply to this email directly, view it on GitHub
<#194436 (comment)>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/CAMPZ2TM4HUSDX5WB6VDDE344HEBFAVCNFSM6AAAAACYMPBFC2VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTOMBTGM2DSMI>
.
Triage notifications on the go with GitHub Mobile for iOS
<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675>
or Android
<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***
com>
|
Beta Was this translation helpful? Give feedback.
-
|
π·οΈ Skill name π― Problem it solves The main issue was not code generation. Before using a skill-style workflow, AI-assisted changes could easily become:
So this skill acts as an operating protocol for AI-assisted SaaS development. It pushes the agent to investigate first, make bounded changes, run relevant checks, and leave clear evidence for review. π SKILL.md / snippet # Production SaaS Agent OS Skill
## Mission
Operate as a disciplined AI engineering agent for a production SaaS monorepo.
Do not only generate code.
Investigate the existing system, make bounded changes, validate them, and prepare work that a human maintainer can safely review.
## Core Rules
1. Prefer small scoped changes over large mixed changes.
2. One task should map to one clear app, package, feature path, or infrastructure concern.
3. Do not stage unrelated files.
4. Do not use broad `git add .`.
5. Inspect existing patterns before adding new code.
6. Preserve i18n, auth, analytics, environment, and deployment boundaries.
7. Treat production deployment logic as high-risk.
8. Never expose secrets or echo credential values.
9. Run the most relevant validation before claiming success.
10. Report files changed, checks run, risks, and next recommended action.
## Pull Request Discipline
A valid PR should usually affect one of:
- one app
- one package
- one feature path
- one infrastructure concern
- one documentation concern
Avoid mixed PRs that combine UI, auth, database, deployment, copy, and infrastructure changes together.
## Validation
Before completing work, run the most relevant checks available, for example:
- pnpm lint
- pnpm test
- pnpm build
- package-specific tests
- route smoke checks
- i18n validation
- deployment-readiness checks
If validation cannot be run, say exactly why.
Do not claim success without evidence.
## Final Report
Every completed task should include:
- what changed
- files touched
- validation run
- known risks
- what should happen nextπ₯οΈ Where it works
It works best in a TypeScript / Next.js / pnpm / Turborepo-style monorepo where app boundaries matter. π‘ One thing I learned For production work, the hard part is not only generating code. The skill became less about βwrite this featureβ and more about:
A good |
Beta Was this translation helpful? Give feedback.
-
|
One thing I am still thinking about is how strict a For example, in a production monorepo, should the skill require the agent to always run the nearest package-level checks before completion, or is it enough for the agent to clearly list the checks that should be run? My current bias is that the skill should require validation whenever possible, because it reduces false confidence. But there is a tradeoff:
Curious how others are handling this in Copilot skills, especially for PR review, monorepos, and production workflows. |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
π Hey Community!
Custom Skills (SKILL.md) are one of the most powerful, and most under-documented, features in GitHub Copilot. We've seen incredible things being built in this community, from deterministic React UI generators to multi-agent orchestration workflows for full-stack development.
But right now, there's no central place to discover what others have built, learn from their SKILL.md file structures, or get inspired for your next custom skill.
Let's change that. π
Share your custom Copilot Skill!
Reply to this thread with:
Not sure where to start?
Here are some skill ideas based on what the community has been asking about:
Quick reference: SKILL.md file structure
For anyone new to custom skills, here's the basic anatomy:
Your
SKILL.mdfile typically contains:π Official docs: Custom skills for Copilot
π Community highlights
We'll periodically update this section with standout skills shared in the replies:
Whether you've built a production-grade skill or just a weekend experiment, we want to see it. The best way to learn SKILL.md is from real examples β and right now, there aren't enough of them.
Let's build that library together. Drop your skill below! π
Beta Was this translation helpful? Give feedback.
All reactions