Super MCP Server Development

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.

Project Architecture

- `query`: Executes SuperSQL queries via the external `super` command

- `list_files`: Discovers data files in directories

Development Workflow

1. Planning Phase

- 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

2. Implementation Phase

- **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

3. Testing Phase

```bash

go mod tidy

go build

./super-mcp-server

```

4. Deployment Phase

Code Style Guidelines

**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)

}

```

GitHub Actions Integration

When mentioned in issues with `@claude`, perform automated research:

**Data Gathering**:

**Research Analysis**:

**Summary Generation**:

Post a comprehensive comment including:

Security Guidelines

Dependencies

Integration Notes

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.

Tool Parameters

Example Usage

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"`