Development workflow for building and maintaining a Lambda-deployable MCP server with embedded SuperDB for data querying. Includes issue research, planning, implementation, testing, and PR creation following Go best practices.
This skill provides a comprehensive development workflow for the Super MCP Server project - a Model Context Protocol (MCP) server implementation in Go that provides SuperSQL querying capabilities. It acts as a bridge between Claude Desktop and the Super data processing tool, allowing natural language queries against various data formats.
- `query`: Executes SuperSQL queries via the external `super` command
- `list_files`: Discovers data files in directories
- Search scratchpads for previous thoughts related to the issue
- Search PRs using `gh pr list --search` to find relevant history
- Use Grep/Glob tools to search the codebase for related functionality
- Review existing tests and documentation for context
- Include the issue name/number in the filename
- Add a link to the issue at the top
- List all implementation steps
- **Imports**: Standard library first, third-party second, internal packages last
- **Error Handling**: Use `if err != nil` with meaningful error returns/wrapping
- **Naming**: camelCase for variables/fields, CamelCase for functions/methods, lowercase for packages
- **Testing**: Use testify for assertions, mock interfaces when needed
- Add only the specific files related to the current task (never use `git commit -a`)
- Write descriptive commit messages without mentioning Claude
```bash
go mod tidy
go build
./super-mcp-server
```
**Imports**:
```go
// Standard library
import (
"context"
"fmt"
)
// Third-party
import (
"github.com/modelcontextprotocol/go-sdk/mcp"
)
// Internal
import (
"github.com/berrydev-ai/super-mcp-server/internal/pkg"
)
```
**Error Handling**:
```go
result, err := someFunction()
if err != nil {
return fmt.Errorf("descriptive context: %w", err)
}
```
**Testing**:
```go
func TestQuery(t *testing.T) {
assert := assert.New(t)
result, err := query("SELECT * FROM data")
assert.NoError(err)
assert.NotNil(result)
}
```
When mentioned in issues with `@claude`, perform automated research:
**Data Gathering**:
**Research Analysis**:
**Summary Generation**:
Post a comprehensive comment including:
This server integrates with Claude Desktop through the MCP protocol. Configuration requires adding the built binary path to `claude_desktop_config.json` under the `mcpServers` section.
When assigned an issue:
1. Run `gh issue view 42` to read the issue
2. Search for related code: `grep -r "query tool" .`
3. Create scratchpad: `scratchpads/issue-42-add-query-timeout.md`
4. Create branch: `git checkout -b issue-42-add-query-timeout`
5. Implement, test, commit incrementally
6. Run `go test ./...` to verify all tests pass
7. Create PR: `gh pr create --title "Add query timeout support" --body "Fixes #42"`
Leave a review
No reviews yet. Be the first to review this skill!
# Download SKILL.md from killerskills.ai/api/skills/super-mcp-server-development/raw