How does it help with database performance?

It identifies common performance bottlenecks such as N+1 queries, suggests appropriate database indexes, and optimizes JOIN operations.

Will it automatically refactor my entire project?

It handles simple, lightweight refactoring and naming fixes. Large-scale architectural changes are out of scope for this skill and should be handled by an Agent.

Can it help me follow Python standards?

Yes, it enforces PEP 8 compliance, encourages the use of type hints, and suggests idiomatic patterns like list comprehensions where appropriate.

What programming languages does this skill support?

This skill specifically supports Ruby (with a focus on Rails), Python, and SQL for database interactions.

Does this skill perform full code reviews?

No, this is a lightweight assistant meant for real-time feedback during implementation. Comprehensive code reviews and security audits should be delegated to a specialized Agent.

Backend Development Assistant

Name: Backend Development Assistant
Author: k-staging

byk-staging

0•

API開発

Provides real-time guidance and best practices for Ruby, Rails, Python, and SQL implementation to ensure code quality and prevent common bugs.

The Backend Development Assistant is a specialized Claude Code skill designed to provide immediate feedback during the implementation phase of backend projects. It acts as a lightweight proactive reviewer, enforcing Rails conventions, PEP 8 standards, and SQL optimization techniques like N+1 query prevention. By catching architectural mistakes and naming inconsistencies before they are committed, it streamlines the development workflow while delegating complex refactors and security audits to comprehensive AI agents for a more efficient coding experience.

主な機能

01Provides proactive warnings on potential bugs before they are implemented

02Identifies and prevents SQL N+1 queries and suggests missing indexes

03Enforces Rails conventions and RESTful routing patterns automatically

040 GitHub stars

05Applies Python PEP 8 standards and type hinting best practices in real-time

06Performs lightweight refactoring and naming convention fixes on the fly

ユースケース

01Writing idiomatic, type-hinted Python code for microservices or data processing scripts

02Optimizing database-heavy applications by fine-tuning SQL JOIN operations and transaction management

03Building RESTful APIs with Ruby on Rails while ensuring strict parameter handling and model validations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add k-staging/ansible-local backend-dev

For use in Claude.ai and ChatGPT

Download Skill